[Zope] ZSQL caching question

[Schmidt, Allen J.]

We have a section of our site delivering online classifieds which are
imported from text file into a Microsoft Access2000 DB and retrieved using
ZSQL methods connecting to Access with a ZODBC adapter. Works fine. Most of
the expensive ZSQL methods are cached in the Advanced tab.

To make the switch to MySQL, I copied the whole Classifieds folder and
renamed it. Then created a MySQL connection to the new database and went
into each ZSQL method and pointed them to the new MySQL DA. I checked the
caches and they are still there.

Problem: Even for one user while testing, the site section is VERY SLOW. Our
admin says while monitoring the MySQL DB the connections go way up and it
loads up the server.

Question: Are the caches 'moving' along with the ZSQL methods when the DB
connection was changed? Grasping at straws but it should be faster than
using Access. The other site we converted to MySQL from Access did not have
the problem and never thought to check the caches...it just worked and was
much faster.

Any ideas or am I just missing something?

Thanks
Allen




-----Original Message-----
From: Jason Earl [mailto:jason.earl@simplot.com]
Sent: Monday, November 12, 2001 2:14 PM
To: csnorville@fedex.com
Cc: zope@zope.org
Subject: Re: [Zope] File I/O in Zope


csnorville@fedex.com writes:

> Hi Everyone, 

Hello

> I am fairly new to Zope and I need some assitance on something that
> I know is fundamental so please don't beat up on me too bad ;-)

I haven't been a member of this list for too terribly long, but the
folks here seem to be pretty darn friendly.

> I am try to open a file with a Python Script in Zope for content
> manipulation. This is a text file, I basically want to read a
> number, operate on it and write it back out.  However when I try to
> get my file handle I get;

You are going to need to use an External Method (or a Product) for
this.  The Zope based Python scripts only offer a "safe" subset of
Python.  Opening files on the filesystem is not a part of this "safe"
subset.

> file=open("/home/chris/misernumber", "r+") 
> 
> Zope Error 
> 
>            Zope has encountered an error while publishing this resource.
> 
>            Error Type: NameError 
>            Error Value: global name 'open' is not defined 
> 
> I tried creating the file as a Zope object but I get the same error.
> Again I know this is fundamental. If ya'll can help me with this, or
> at least point me to some documentation it would be deeply
> appreciated.

There probably is a way to do this with Zope objects, but it wouldn't
be using open().  There is a whole slew of methods for manipulating
Zope objects, check the Zope API section in the Zope Book.

Depending on what you are actually trying to do there might be a more
Zope-like way of accomplishing it than with the External Method
hammer, but without knowing what you are trying to do it is hard to
guess what that more Zope-like thing should be.

Jason

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )