Thread: pgODBC slow

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    59
    Rep Power
    12

    pgODBC slow


    Hello,

    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

    Thanks

    Rhys
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Posts
    56
    Rep Power
    12
    Try running the query in psql directly, use EXPLAIN ANALYZE to see the query plan.
    Casuistry Agnostic
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    59
    Rep Power
    12
    Thanks for that,

    I have discovered that ODBC Tracing was on, I turned this off and solved the problem

    Thanks Again

    Rhys

IMN logo majestic logo threadwatch logo seochat tools logo