ADOQuery slow

From: Zhuo (zli_at_micros.com)
Date: 02/24/05

Next message: Kjell Rilbe: "Re: ADO + CoInitialize in threads? Mystery..."
Previous message: Patrick: "Re: Could not convert variant of type (Null) into type (String)"
Next in thread: Arnie: "Re: ADOQuery slow"
Reply: Arnie: "Re: ADOQuery slow"
Reply: Brian Bushay TeamB: "Re: ADOQuery slow"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Thu, 24 Feb 2005 15:59:17 -0500

I am converting BDE to ADO. One ADO query was executed one hundred times
(with different parameters), each time it got a record from the database
(ORACLE 8.1.7/ASA 6.0). It took about 2 seconds for fetching these 100
records. However, if I use BDE for Oracle and Sybase or Direct Oracle
Access for Oracle only, it likes a blink of eyes.

Any ideas how to improve the speed?
Thanks,
Zhuo

Next message: Kjell Rilbe: "Re: ADO + CoInitialize in threads? Mystery..."
Previous message: Patrick: "Re: Could not convert variant of type (Null) into type (String)"
Next in thread: Arnie: "Re: ADOQuery slow"
Reply: Arnie: "Re: ADOQuery slow"
Reply: Brian Bushay TeamB: "Re: ADOQuery slow"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: ADOQuery slow
... "Zhuo" wrote in message ... >I am converting BDE to ADO. ... One ADO query was executed one hundred times ... if I use BDE for Oracle and Sybase or Direct Oracle ...
(borland.public.delphi.database.ado)
Re: ADOQuery slow
... your strategy a little and use a stored procedure instead... ... > I am converting BDE to ADO. ... One ADO query was executed one hundred times ... if I use BDE for Oracle and Sybase or Direct Oracle ...
(borland.public.delphi.database.ado)
Re: TADOQuery slow inserts in Oracle
... If you insert into Oracle, ... I'm currently using the MS provider, for some reason I don't have the ... No can do, doing a data transfer from an MS SQL Server into Oracle, so ... basically looping off of one ADO query from MS SQL and inserting into ...
(borland.public.delphi.database.ado)