Search found 2 matches

by mobileuser
18.02.2008, 19:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Wrong codepage
Replies: 0
Views: 725

Wrong codepage

I have the table CREATE TABLE `patient` ( `idPatient` int(10) unsigned NOT NULL auto_increment, `LName` varchar(45) default NULL, `FName` varchar(45) default NULL, `PName` varchar(45) default NULL, `Street` varchar(45) default NULL, `House` int(10) unsigned default NULL, `Building` varchar(3) defaul...
by mobileuser
25.12.2006, 19:04
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Low speed Locate in TZReadOnlyQuery
Replies: 1
Views: 1008

Low speed Locate in TZReadOnlyQuery

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