Re: ADO find method performance

Mr.Sajal@xxxxxxxxx wrote:
Hi,
I am developing one application where i need to search for record in
the ado recordset. i am giving search crieteria on a indexed(ID)
field. depending upon that record i need to fetch other field values.

my ado record set is created though client side cursor. and it
contains 1 million data and it can be 10/20 millions of record. what i
do is i just create a client side recordset for that ID field along
with required other 3 fields. those 3 field values i need for an ID
value.

ADO find method works fine when record counts are less but it dies for
millions of record.
Is there any performant way to achieve this??

Can you not modify the sql statement used to retrieve the records to only
retrieve the ones you want? The database engine (what database are you using
by the way?) is likely to be far superior to the ADO cursor library when it
comes to searching for records. If you provide more details, it is very
likely that we could help you create a sql statement to only retrieve the
records you really need.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.