Re: Locate Speed in ADO
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Thu, 26 Jan 2006 20:42:19 -0600
>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?
As long as you are using Access in tableDirect mode you can use Seek instead of
Locate. Seek will use your index
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Locate Speed in ADO
- From: Fatih Tolga Ata
- Locate Speed in ADO
- Prev by Date: Re: dbExpress or ADO?
- Next by Date: TADOQuery.Open() & Sybase
- Previous by thread: Re: Locate Speed in ADO
- Next by thread: TADOQuery.Open() & Sybase
- Index(es):
Relevant Pages
|
