August 13th, 2002, 03:42 AM
I am using pgODBC, when I query some data (using VB ADO) my hard drive works for a few seconds then the result is returned,
Why would this delay happen?
The database has less than 1000 rows
August 14th, 2002, 07:03 PM
Try running the query in psql directly, use EXPLAIN ANALYZE to see the query plan.
August 14th, 2002, 08:16 PM
Thanks for that,
I have discovered that ODBC Tracing was on, I turned this off and solved the problem