On 31 Aug 2004 at 19:26, Kroh Istv n wrote:
> This should return a single varchar(20) field. Running this query over
> ADO/ODBC from a Delphi app tooks 50-100 secs. If i run this from
> pgAdmin II. it takes some msecs.
I have found instantiating and using the ADO objects directly to be
much faster than using the TADOConnection and TADOQuery components
that come with Delphi. - This is in web apps where I'd construct the
SQL and execute it with the Connection object.
--Ray.
-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------