Re: Trouble with slow ODBC query via Access - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Trouble with slow ODBC query via Access
Date
Msg-id 3E26780A.6B51DED3@tpf.co.jp
Whole thread Raw
In response to Trouble with slow ODBC query via Access  (Benjamin Scherrey <scherrey@proteus-tech.com>)
List pgsql-odbc
Benjamin Scherrey wrote:
>
> I've replaced the backend of that large nasty Access db with PostgreSQL 7.3. It seems to be
> workin quite well except one table refuses to work well with an indexed field. Its a simple integer
> with a unique index - other tables have them too and seem to work. However, when I do a find on it
> for this particular table it insists on running through every record in the table and manually searching
> for the value rather than a simple select for the value.

Could you tell me the definition of the table ?

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/

pgsql-odbc by date:

Previous
From: srihari
Date:
Subject: Linux IDE's
Next
From: Steve Crawford
Date:
Subject: Re: Linux IDE's