Skip site navigation (1) Skip section navigation (2)

ODBC is slow with M$-Access Report

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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'


In response to

Responses

pgsql-hackers by date

Next:From: David HartwigDate: 1998-05-28 14:06:43
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
Previous:From: Andreas ZeugswetterDate: 1998-05-28 09:41:47
Subject: Re: [HACKERS] removal of exec()

pgsql-interfaces by date

Next:From: David HartwigDate: 1998-05-28 14:06:43
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
Previous:From: Byron NikolaidisDate: 1998-05-28 01:08:59
Subject: Re: [INTERFACES] pgsql ODBC sources

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group