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