Search found 2 matches
- 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...
- 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
Delphi 7 and MySQL 4.1