ODBC Performance Question - Mailing list 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