Locate Speed in ADO

From: Fatih Tolga Ata <fatih@xxxxxxxxxxx>
Date: Wed, 25 Jan 2006 21:47:14 +0200

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,
.

Follow-Ups:
- Re: Locate Speed in ADO
  - From: Brian Bushay TeamB
- Re: Locate Speed in ADO
  - From: Kevin Frevert

Prev by Date: Programatically add a constraint. ADOX?
Next by Date: Re: BOF or EOF error -MSAccess Fixed
Previous by thread: Programatically add a constraint. ADOX?
Next by thread: Re: Locate Speed in ADO
Index(es):
- Date
- Thread

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)
Re: Locate Speed in ADO
... ADO Speed Techniques with Delphi - Part I ... > I have a database that has about 150000 records. ... > and filter about 50-100 ms. ... One of them is ID, and other is a string field ...
(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)
Re: Date criteria
... Edgar wrote: ... I then have a criteria on this field as follows: ... You basically converted a date field into a string field. ... Maybe filter on the dates. ...
(comp.databases.ms-access)