Re: Trouble with slow ODBC query via Access

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Trouble with slow ODBC query via Access
Date: 2003-01-16 09:14:50
Message-ID: 3E26780A.6B51DED3@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Steve Crawford 2003-01-16 16:40:12 Re: Linux IDE's
Previous Message srihari 2003-01-16 06:17:11 Linux IDE's