| From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
|---|---|
| To: | Kroh Istv n <istvan(dot)kroh(at)pomme(dot)hu>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: odbc/ado problems |
| Date: | 2004-09-02 10:46:02 |
| Message-ID: | 413707FA.23200.282B24@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc pgsql-performance |
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(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lchan | 2004-09-02 21:09:27 | [HELP] can't get Unixiodbc to connect to SQL |
| Previous Message | Kroh István | 2004-09-01 09:04:52 | Fw: odbc/ado problems |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2004-09-02 13:43:40 | Multiple Uniques |
| Previous Message | Merlin Moncure | 2004-09-01 17:53:18 | Re: seqscan instead of index scan |