Horton

ODBC is slow with M$-Access Report

jose' soares <sferac@bo.nettuno.it>

View thread
From: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Date: 1998-05-28T10:50:19Z
Lists: pgsql-hackers 
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'