i'm using Delphi-7 and zeos 6.6.4 (and just now upgrading to zeos 7.1.4) upon bigger rows of a table, things become very very slow on query. Not so much rows either (on salesdetail my table got around 200k rows). after I backup and clean the table, it's very fast.
I'm pretty sure the problem is in ZQuery1.Open. I copy paste the "search/select query" and run it on mysql and it only took 1sec or so. -> So I'm sure it's not my query's fault. But if i execute it on Delphi7, it took around 15secs.
I did some tracing, and i found out the problem is on ZQuery1.Open, after pass this code, things run at normal speed.
tried upgraded zeos to newest version, but problem persist.
any solutions?
thank you.
EDIT: I read similar case on this:
"guyvdb wrote: Hello, we did also some tests and came to the same conclusion. 'qry.open' is very slow with ZEOS. Speed is significantly better with 'ADO' and 'SQLDirect' Disabling the debug define in zeos.inc doesn't change anything."
http://zeoslib.sourceforge.net/viewtopic.php?t=120
i'm pretty much prefer keep using zeos, not changed to ADOquery,etc because the app is finished already, the problem discovered months after used, after bigger data on table.and it will be much work to change all the zquery into something else. thank you
Setting to
TZConnection.SQLHourGlass := false