Re: Locate Speed in ADO

Fatih,

Try wrapping .DisableControls/.EnableControls around the .Locate.

ADO Speed Techniques with Delphi - Part I
http://bdn.borland.com/article/0,1410,27790,00.html

Good luck,
krf

"Fatih Tolga Ata" <fatih@xxxxxxxxxxx> wrote in message
news:43d7d50a$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I have a database that has about 150000 records. I must locate immediately
> a row on a string field. Befere using ado, I used BDE. And I can locate
> and filter about 50-100 ms. But now, I am using ado, locating and
> filtering takes about 1500-4000 ms. I created index in mdb. The table has
> 2 field. One of them is ID(Primary, Integer), and other is a string field
> that I try to search. I tried ADOTable and ADOQuery. However,
> CursorLocation is clServer, TableDirect is True, IndexName is the string
> field's index name. I created index in ms access. What can I do?
>
> Regards,


.

Relevant Pages

  • Re: Locate Speed in ADO
    ... >immediately a row on a string field. ... Befere using ado, I used BDE. ... >can locate and filter about 50-100 ms. ... As long as you are using Access in tableDirect mode you can use Seek instead of ...
    (borland.public.delphi.database.ado)
  • Locate Speed in ADO
    ... Befere using ado, I used BDE. ... And I can locate and filter about 50-100 ms. ... But now, I am using ado, locating and filtering takes about 1500-4000 ms. ... One of them is ID, and other is a string field that I try to search. ...
    (borland.public.delphi.database.ado)
  • Re: mysql date format
    ... Woo wrote: ... Thanks for the info on getvalue. ... But the result from it was a string field ... I am not using ADO as I am using DSN to perform database connection. ...
    (microsoft.public.dotnet.languages.vb)
  • Filtering with TClientDataSet connected to ADO
    ... I want my client to be able to filter dataset dynamically ie choose field ... connected thru ADO to MSSQL 2000. ... The database sometimes returns MyString ...
    (borland.public.delphi.database.ado)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)