[Zope] Experience with Zope and Access ?

[Schmidt, Allen J.]

I know...I did not mean to imply it was Zope's problem...I really think Zope
is very fast using Access/ODBC. In fact, I am trying to convert one of
'products' from Access/ODBC to MySQL and there is a significant speed
decrease and increased load on the MySQL server. Not sure why. I copied the
folder containing everything, added a MySQL adapter and change the ZSQL
methods to use the new DA. Then renamed the folders to put the new one into
production and everything came to a crawl. All the queries had caches one
them and it seemed they were not being used. Today, I deleted the queries
and recreated them to make sure they were not 'holding' onto something...no
difference. Even just me accessing it, it seems much slower than the
Access/ODBC site in production being pounded on by users.

If anyone has any ideas, I would be glad to hear them...

Allen

-----Original Message-----
From: Tino Wildenhain [mailto:tino@wildenhain.de]
Sent: Tuesday, November 13, 2001 9:41 AM
To: Schmidt, Allen J.; 'Marc Gehling'; zope@zope.org
Subject: RE: [Zope] Experience with Zope and Access ?


Hi,

--On Tuesday, November 13, 2001 07:12:33 -0500 "Schmidt, Allen J." 
<aschmidt@nv.cc.va.us> wrote:

> we have been using Zope/Access for almost a year now. Works really well
> and have had no problems. The only thing I don't like is that Zope locks
> the MDB file so you can't copy it or open it with anything else. We

This is not the problem of Zope but the problem of Access and its ODBC 
driver :-)


> converted one system to MySQL and use a remote tool to gain access to the
> remote DB on the server. Works well.

Regards
Tino Wildenhain