Re: Ado Oracle Performance

Hi,

"Guy" <cobra001@xxxxxxxxxxxxxxx> escribió en el mensaje
news:425e41f8$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hello
>
> I am using ado via ODBC to connect to an oracle database. What i notice
> is
> that executing queries even on an empty table takes 2-3 seconds for the
> query to complete. Selecting 28000 records from a table takes over 40
> seconds while the same query thru sql explorer using the same ODBC
> connection completes in 1-2 seconds.
> Is ADO that slow or are there properties/ cache that i need to set.

You're adding an extra layer by using ADO + ODBC. It's completely normal
that it is slower than only using ODBC. Instead of using ODBC use the Oracle
OLE DB provider. It comes with MDAC.

>
> I am using Delphi 7.1 Enterprise and have query component connected to an
> ado connection. All the other properties are the default except for the
> connection string.

Build your connection string to use the Oracle OLE DB provider.

Hope that helps
--
Best regards :)

Guillem Vicens
Dep. informática Green Service SA
guillemvicens@xxxxxxxxxxxxxxxxxx
www.clubgreenoasis.com


.