Re: Speed problem with mssql 2000 and ado
From: Vitali Kalinin (vitkalinin_at_yahoo.com)
Date: 03/26/04
- Next message: Kirk Evans: "Using TADOConnection in Console App"
- Previous message: Terry: "Re: row cannot be located"
- In reply to: Sascha Schroeder: "Speed problem with mssql 2000 and ado"
- Next in thread: Arnie Mauer: "Re: Speed problem with mssql 2000 and ado"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 26 Mar 2004 17:40:40 +0200
You can DisableControls for TADODataSet before looping. Also I recommend you
to not bother MS SQL Server with 1000 sequential calls for different ids, I
believe that should be better way do accomplish it. Most preferable would be
extract all necessary data within single select or you can split 1000 ids on
batches with 100 ids in each and request 100 values within single query.
Regards,
Vitali
"Sascha Schroeder" <sascha.schroeder@e-pro.de> сообщил/сообщила в новостях
следующее: news:40643cf0@newsgroups.borland.com...
> We are evaluating ado with delphi 7. Our application uses the bde to
connect
> to
> mssql and oracle. Now we are using nvarchar and ntext in our mssql
database
> to
> store unicode data. if we connect to this database with ado and select
some
> data we receive
> the data very slow. we have a select
>
> SELECT FIELD1, FIELD2 FROM TABLE1 WHERE ID = :Id)
>
> FIELD1 = nvarchar(255)
> FIELD2 = ntext
> Id = integer
>
> which is executed one thousand times in a loop. The complete loop takes
> about 70 seconds!!!
> with bde it takes 7 seconds. if we connect to a database without nvarchar
it
> takes about 12
> seconds with the bde.
>
> What can we do to increase the performance with ado?
>
> With Oracle we have no speed problems.
>
> Thank you very much for your help,
>
> Sascha
>
>
- Next message: Kirk Evans: "Using TADOConnection in Console App"
- Previous message: Terry: "Re: row cannot be located"
- In reply to: Sascha Schroeder: "Speed problem with mssql 2000 and ado"
- Next in thread: Arnie Mauer: "Re: Speed problem with mssql 2000 and ado"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
