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
