Zeoslib Portal

Posted: **25.12.2006, 19:04**

I've selected around 166000 records from Mysql table. If I use TZReadOnlyQuer.Locate(field,fieldvalue,[]) then the method executes 10 minutes or great. And if I use TZQuery then the method execute in a moment. Why?
Delphi 7 and MySQL 4.1

Posted: **20.02.2007, 21:09**

I have also this problem. TZQuery is mutch faster but if I set ReadOnly=True it is slow as a TZReadOnlyQuery.
Sorry for my english

Zeoslib Portal

Low speed Locate in TZReadOnlyQuery

Low speed Locate in TZReadOnlyQuery