Am 05.04.2007, 20:28 Uhr, schrieb Dev Sen <[EMAIL PROTECTED]>:

This is my first post to the list, so I hope my question isn¹t too naïve.
I am developing a database app in Zope/Plone using MySQL with the egenix DB
adaptor on a Mac Pro. So far everything with the adaptor has been good,
although I am now having strange issues. I have some queries which return
around 5,000 rows of data. When I run the query with parameters so that only 1200 or so rows are returned there is no problem, however, for larger result sets I get an error saying the connection to the database was lost. Another
developer working on the same project (identical code, software versions)
but running Windows XP doesn¹t have this problem at all. Also, running the queries directly in MySQL works fine. Therefore we think it has something to
do with the Mac OSX version of the egenix DB adaptor.
Has anyone seen this behavior before? Is this a known bug?


I believe that MySQL has only just released their ODBC driver for Mac OS X and this is where we suspect the problem is so it's probably a good idea to make sure you have the most uptodate version of this driver. As for limiting the number of rows returned. Are you doing this through the advanced tab in the ZSQL method or through LIMIT in the SQL statement? MySQL (MyASM tables) can be unbelievably slow on certain types of query such as ANSI INNER JOINS or subselects but if you enforce a hard LIMIT in your SQL there should be no reason for a timeout as maybe happening here.

Charlie Clark

Charlie Clark

Professional Python Services directly from the Source
Python/Zope Consulting and Support ...
mxODBC.Zope.Database.Adapter ...   
mxODBC, mxDateTime, mxTextTools ...

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! :::: Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
Zope-DB mailing list

Reply via email to