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
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 |