I have a customer who is running PostgreSQL 8.1. I recently updated an application there, and it is running extremely slowly. The previous version of the application runs fine, and the new version runs fine on my machine, which runs PostgresQL 8.4. The problem is that a query for a single record from a 100,000-record database is taking 8 seconds when the ADO recordset is set to use a client-side cursor, while it only takes a few milliseconds for a server-side cursor. But if I use a server-side cursor, I get the "query-based update cannot find row to update" error.
I wanted to try using the ODBC driver for PostgreSQL 8.4. But when I installed it, I was surprised and dismayed to see that the old driver no longer appeared in the list of available drivers when I tried to create a new DSN. At first, I thought that the new driver was working, but any update query gave me a "multiple-step operation raised errors. See error list" error.
Is it possible to have the 8.1 and 8.4 ODBC drivers available at the same time? If so, how do I install the 8.4 driver so that the 8.1 driver is still available?
Thanks very much!
RobR