Skip site navigation (1) Skip section navigation (2)

queries run twice unless 'parse statements' checked?

From: "Johann" <johann(at)tygerpos(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: queries run twice unless 'parse statements' checked?
Date: 2005-02-07 04:20:04
Message-ID: 6.1.0.6.0.20050206211234.01d4aac0@pop.dnvr.uswest.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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 by date

Next:From: Layet BenjaminDate: 2005-02-07 07:04:07
Subject: ODBC & character encoding
Previous:From: Marco TamantiDate: 2005-02-06 03:35:41
Subject: varchar problem after installing postgresql-8.0.1 on windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group