queries run twice unless 'parse statements' checked?

Поиск
Список
Период
Сортировка
Искать
От
Johann
Тема
queries run twice unless 'parse statements' checked?
Дата
Msg-id
6.1.0.6.0.20050206211234.01d4aac0@pop.dnvr.uswest.net
Список
Дерево обсуждения
Re: queries run twice unless 'parse statements' checked? "Dave Page" <dpage@vale-housing.co.uk>
Running PostgreSQL 8.0, client is Visual Basic program using ADO, test case 
has one adodc and a bound grid.

Queries involving a 188,000 row table were slow, even when query was on 
single value in uniquely keyed index.

Turns out - from checking the plsqlodbc file, it was executing the query 
once like I said:

select something from somewhere where thing=value

[returning one row]

then it ran the query again without the where clause [really!]

SELECT something FROM somewhere (The second query had the keywords turned 
to upper case, if that helps identify what's going on.)

[returning 188,000 rows]

Naturally, this made things run slowly.  I fiddled around and eventually 
found that by checking "Parse Statements", this behavior stopped.

Anyway - is it supposed to work this way?

	- Johann

В списке pgsql-odbc по дате отправления
От: Dave Page
Дата:
Сообщение: Re: New release
От: Ramon Danieli
Дата:
Сообщение: Unix domain socket
FAQ