ADO and SQL2K5 and Speed

From: "Kendrick" <kkendrick@xxxxxxxxxxxxx>
Date: Sat, 22 Dec 2007 18:57:12 -0800

I am iterating a TClientdataset and then checking a destination table for a
matching record using Tdataset.Locate with the values of a unique index and
then editing if true or appending if not. I am comparing the process between
Advantage Data Server via their TAdsTable component and a MSSQL2K5 via ADO.
440 records of moderate size takes less than one second for Advantage and 40
seconds for MSSQL. Any hints for improvement? (my first ADO endeavor and
first MSSQL).

.

Follow-Ups:
- Re: ADO and SQL2K5 and Speed
  - From: Bill Todd

Prev by Date: Re: ADO and SQL2K5 and Speed
Next by Date: Getting TAdoQuery extended informations about error
Previous by thread: Bug? in TADOConnection.SetConnectionObject
Next by thread: Re: ADO and SQL2K5 and Speed
Index(es):
- Date
- Thread