| From: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> |
|---|---|
| To: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
| Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | ODBC is slow with M$-Access Report |
| Date: | 1998-05-28 10:50:19 |
| Message-ID: | Pine.LNX.3.96.980528103733.942A-100000@proxy.bazzanese.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Hi,
I'm using PostgreSQL-6.3 / psqlodbc 06.30.0242 / M$-Access97.
I created a REPORT with a leftjoin that takes a lot of time.
There are 3850 rows in the main table.
PostgreSQL takes about..............: 960 secs to print all records.
The same test using MySQL takes only: 85 secs and the same
test using M$-Access takes about....: 45 secs.
I configured ODBC drive to write the log file to sees what ODBC is doing
but seems that it writes log file only while fetching rows.
Is there a way to know what ODBC is doing. To know why it takes so long time?
Thanks, Jose'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Hartwig | 1998-05-28 14:06:43 | Re: [INTERFACES] ODBC is slow with M$-Access Report |
| Previous Message | Andreas Zeugswetter | 1998-05-28 09:41:47 | Re: [HACKERS] removal of exec() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Hartwig | 1998-05-28 14:06:43 | Re: [INTERFACES] ODBC is slow with M$-Access Report |
| Previous Message | Byron Nikolaidis | 1998-05-28 01:08:59 | Re: [INTERFACES] pgsql ODBC sources |