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

Re: [INTERFACES] ODBC is slow with M$-Access Report

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org>, hackers postgres <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
Date: 1998-06-03 10:48:06
Message-ID: Pine.LNX.3.96.980603104111.745A-100000@proxy.bazzanese.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
On Tue, 2 Jun 1998, David Hartwig wrote:

<DELETED>
> > Nikolaidis and David Hartwig of insightdist.com that are doing a
> > really great job with ODBC driver), but with the obvious consequences.
> 
>  I am currently working on a solution as time will allow.   Hopefully part of 6.4
> > 2.  As PostgreSQL doesn't allow an "ORDER BY" on columns not
> > included in the target list of the "SELECT", (I know that it is
> > SQL/92 standard, but IMO it's a fool thing), therefore, is not possible
> > to  have the "dynaset "sorted for any field that is different from
> > the key (in our case the useless OIDs).
> 
> This fix is in alpha and will be in the 6.4 release.  I do not know when 6.4 is slated
> for release, but I am willing to send you a patch if it is critical for you to proceed.
> 
> > 3. The times required to run complex reports (for example those that
> > include LEFT JOINS) is very long (about 15 minutes to retrieve
> > 2850 rows).
> >
> The solution to your first item will resolve this also.
> 
This is a great new David, Thank you very much for your work, this allow us
to go on with this important project.
For us, is enough to know that it will be available *maybe* on next release.
                                               Thanks a lot, Jose'


In response to

pgsql-hackers by date

Next:From: Jose' Soares Da SilvaDate: 1998-06-03 11:02:06
Subject: Re: [HACKERS] Re: [INTERFACES] ODBC is slow with M$-Access Report
Previous:From: Brett McCormickDate: 1998-06-03 09:37:58
Subject: Re: [HACKERS] keeping track of connections

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-06-03 11:02:06
Subject: Re: [HACKERS] Re: [INTERFACES] ODBC is slow with M$-Access Report
Previous:From: Paul RobertsDate: 1998-06-03 07:40:23
Subject: M$oft Win95, ODBC and 'crypt-ed' Passwords

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