Re: [HACKERS] Single row fetch from backend

> 
> Hmmm, I've had pretty bad experiences with cursors on Informix Online. When
> many clients use cursors on large result sets the system (even on big iron)
> grinds to a halt. Luckily you can fetch a single row at a time on a normal
> select with Informix so that solved that. It does appear, however, that
> Postgres does not create huge overheads for cursors, but I would still like
> to see what happens when many clients do a cursor select...

I believe later Informix ODBC version cache the query reqults in the sql
server in case they are needed later.  Terrible for performance.  I have
clients downgrade to older isql clients.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026