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

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

From: Hannu Krosing <hannu(at)trust(dot)ee>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>, 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-02 17:11:41
Message-ID: 3574324D.8DE61386@trust.ee (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
David Hartwig wrote:
> 
> > 1. The PostgreSQL doesn't use the index with  "OR"  operator  and
> > so is not possible to define a multiple key to use with M$-Access
> > and we need to retreat using OID as primary keys (thanks to Byron
> > 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
> 

Will this solution be in ODBC driver (rewrite ORs to UNION) or in 
the backend (fix the optimiser)?

------
Hannu

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-02 17:26:00
Subject: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches)
Previous:From: Bruce MomjianDate: 1998-06-02 17:08:27
Subject: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches)

pgsql-interfaces by date

Next:From: Tim BosiniusDate: 1998-06-02 17:33:54
Subject: RE: [INTERFACES] whoops: VB RDO works just fine with new odbc dri ver....
Previous:From: The Hermit HackerDate: 1998-06-02 16:34:40
Subject: Re: [HACKERS] Re: [INTERFACES] ODBC is slow with M$-Access Report

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