MYSQL: Fast search method
Posted on 2006-06-22
Hi Everybody, I'm using the TTABLE.Locate(Fieldname,value,) method and find it very very very slow in locating a certain record specially when searching >30,000 records. Do delphi has a searching capability that works fast in locating a certain record? Can you gave me a sample code for this?
I have a TEDIT and DBGrid, everythime the user input a value inside TEDIT (ONCHANGED METHOD) ttable.locate is executed and point the record if it exists, TDBGRID then do the display in pointing the record. This works very very slow when the table has a large record inside.
Thank you very much in advance.