Speed problem with mssql 2000 and ado

From: Sascha Schroeder (sascha.schroeder_at_e-pro.de)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 15:23:44 +0100

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

Relevant Pages

  • ADO problems with ntext, nvarchars
    ... Having problems with ADO returning nothing from table fields of type ... ntext and nvarchar. ... and don't be so blindly stupid etc etc etc, ...
    (microsoft.public.sqlserver.programming)
  • Problems with ntext, nvarchar
    ... I am having problems in my ASP code (ADO) getting any data of type ... ntext or nvarchar from the database. ...
    (microsoft.public.sqlserver.programming)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: BDE support??
    ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
    (borland.public.delphi.non-technical)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)