Low speed Locate in TZReadOnlyQuery

mobileuser · Post by **mobileuser** » 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

designshouse · Post by **designshouse** » 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