Re: Speed problem with mssql 2000 and ado
From: Arnie Mauer (xxx_at_nowhere.net)
Date: 03/26/04
- Next message: Danny Heijl: "Re: Using TADOConnection in Console App"
- Previous message: Franz-Leo Chomse: "Re: Microsoft Jet 4.0 OLD DB Provider"
- In reply to: Sascha Schroeder: "Speed problem with mssql 2000 and ado"
- Next in thread: Brian Bushay TeamB: "Re: Speed problem with mssql 2000 and ado"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 26 Mar 2004 11:09:52 -0500
"Sascha Schroeder" <sascha.schroeder@e-pro.de> wrote in message
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
Try using a server side cursor (clUseServer) and a cursor type of
ctForwardOnly. Set these before you open the query or dataset.
- Arnie
- Next message: Danny Heijl: "Re: Using TADOConnection in Console App"
- Previous message: Franz-Leo Chomse: "Re: Microsoft Jet 4.0 OLD DB Provider"
- In reply to: Sascha Schroeder: "Speed problem with mssql 2000 and ado"
- Next in thread: Brian Bushay TeamB: "Re: Speed problem with mssql 2000 and ado"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
