Trouble with slow ODBC query via Access

Поиск
Список
Период
Сортировка
Искать
От
Benjamin Scherrey
Тема
Trouble with slow ODBC query via Access
Дата
Msg-id
6165NIGBHDWR4ZTQV531IDUA86NM.3e25ceb1@BONZO
Список
Дерево обсуждения
Trouble with slow ODBC query via Access Benjamin Scherrey <scherrey@proteus-tech.com>
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
Дата:
От: srihari
Дата:
Сообщение: Linux IDE's
FAQ