ODBC Performance Question

From: Michael Calabrese <m2calabr(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Performance Question
Date: 2003-02-04 22:05:32
Message-ID: 20030204220532.52037.qmail@web10705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Here is my basic question: Should I expect a query
that returns 0 tuples run in the same amount of time
(give or take a second) through the ODBC and running
the query through psql?

Here is the experiment:
Turned logging on.
MS Access runs query (and does not come back)
Get query out of log that MS Access ran
copy to psql

MS Access times out (like 3 minutes or more)
psql 12 seconds

What I am using:
Access 97
psql odbc 7.2.5
psql 7.3.0

The querry if you are interested (it is alittle ugly):
SELECT
"public"."contacts"."id","public"."orders"."orderid",

"public"."orderdetails"."orderdetid","public"."buildabike"."buildabikeid",
"public"."bikes_basicframetypes"."frametypeid",

"public"."contacts_currentframe_babid"."buildabikeid"
FROM
"public"."orderdetails","public"."buildabike","public"."contacts_currentframe_babid",

"public"."orders","public"."bikes_basicframetypes","public"."contacts"
WHERE (((((((("public"."orderdetails"."buildabikeid"
> 0 )
AND ("public"."orderdetails"."partid" = 6502 ) )
AND ("public"."orderdetails"."buildabikeid" =
"public"."buildabike"."buildabikeid" ) )
AND ("public"."buildabike"."buildabikeid" =
"public"."contacts_currentframe_babid"."buildabikeid"
) )
AND ("public"."orders"."orderid" =
"public"."orderdetails"."orderid" ) )
AND ("public"."buildabike"."frametypeid" =
"public"."bikes_basicframetypes"."frametypeid" ) )
AND ("public"."contacts"."id" =
"public"."orders"."custid" ) )
AND ((NOT(("public"."contacts"."status" LIKE
'Pros%' ) )
AND NOT(("public"."contacts"."willshow" LIKE 'n%' )
) )
AND (lower("public"."contacts"."lastname" ) LIKE
'cala,m%' ) ) )
ORDER BY "public"."bikes_basicframetypes"."framename"
,"public"."contacts"."lastname" ,
"public"."contacts"."firstname"
;

Thanks for any help,
Michael

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Browse pgsql-odbc by date

  From Date Subject
Next Message Alain Picard 2003-02-04 22:41:33 Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?
Previous Message Support 2003-02-04 18:44:36 Fw: problem on treatment when add a duplicate primary key