#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    3
    Rep Power
    0

    psql-odbc performance


    Hi:
    I have a question. I know my problem is not on the server side. But I have very low performance,using ODBC driver and offline recordset of Visual Basic.

    Some tests:
    MSQL (ODBC) = less than 1 second
    pgsql (ODBC) = more than 8 minutes.

    pgsql(console) = less than 1 second.

    I think this Visual Basic component may be a problem, but I have to use it.

    I looking for a OLEDB provider for Postgres, but there is in development phase.

    I apreciate any help

    Thanks,
    Mauricio Fernández
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Exactly what do you mean by "offline recordsets"? Maybe it would be good to describe your exact situation as much as possible. Are you running the client and server on same machine, or is the client connecting over a network? Have you done any optimization of postgresql.conf? What sort of query are you running, and how big is the table(s) involved?
    MSQL (ODBC) = less than 1 second
    pgsql (ODBC) = more than 8 minutes.
    A difference this big is hardly likely to be a software problem. I think it is more likely there is a conceptual problem involved.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo