RE: Cursor gets slower and slower

Posted in 2000

Parker, Jack — Tue, 14 Nov 2000 08:41:37 -0500 — source: Informix-list mailing list archive (1991-1998)

This is typical of a memory overflow situation. If you bump your PDQ to a higher setting you may see this improve. What is the query? cheers j. > -----Original Message----- > From: Chris Notz [mailto:chris.notz@gmx.ch] > Sent: Monday, November 13, 2000 3:45 PM > To: informix-list@iiug.org > Subject: Cursor gets slower and slower > > > Hi > > We have a cursor with about 600'000 records. And it seems, that the > cursor moves slower and slower through the records. At the > beginning, it > is very fast. At about 10% (at record #60'000) it is 10 to 20 times > slower! > > Is it true, the more records are in a cursor the slower is > the progress > of the records later in the cursor? > > Thanx for any answers > Chris >