Trouble with slow ODBC query via Access

Поиск
Список
Период
Сортировка
От Benjamin Scherrey
Тема Trouble with slow ODBC query via Access
Дата
Msg-id 6165NIGBHDWR4ZTQV531IDUA86NM.3e25ceb1@BONZO
обсуждение исходный текст
Список pgsql-odbc
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.

Is this possibly something that the ODBC drivers address? I'm using PostgreSQL+Unicode(Beta)
7.02.00.04. If not - does anyone know how to execute a simple pass thru SQL statement via
Access 2002?

    many thanx,

        Ben Scherrey



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

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: Re: Question about cursor behavior and declare/fetch
Следующее
От: srihari
Дата:
Сообщение: Linux IDE's