Postgres Pro
Downloads
Home   >   mailing lists

ODBC is slow with M$-Access Report - Mailing list pgsql-interfaces

From Jose' Soares Da Silva
Subject ODBC is slow with M$-Access Report
Date
Msg-id Pine.LNX.3.96.980528103733.942A-100000@proxy.bazzanese.com
Whole thread Raw
In response to Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'  (Byron Nikolaidis <byronn@insightdist.com>)
List pgsql-interfaces
Tree view 
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'

pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] pgsql ODBC sources
Next
From: David Hartwig
Date:
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report