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 по дате отправления