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

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: [INTERFACES] ODBC is slow with M$-Access Report
Дата
Msg-id 3574324D.8DE61386@trust.ee
обсуждение исходный текст
Ответ на Re: [INTERFACES] ODBC is slow with M$-Access Report  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Список pgsql-hackers
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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [GENERAL] Re: [HACKERS] custom types and optimization
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches)