November 3rd, 2003, 02:07 PM
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.
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
November 3rd, 2003, 11:25 PM
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?
A difference this big is hardly likely to be a software problem. I think it is more likely there is a conceptual problem involved.