RE: Running 4GL on table that changes a lot

Posted in 2005

Dirk Moolman — Wed, 12 Jan 2005 12:23:20 +0200 — source: Usenet: comp.databases.informix

-----Original Message----- From: Obnoxio The Chav [mailto:obnoxio@serendipita.com] Sent: 11 January 2005 10:23 PM To: Dirk Moolman > > > > Yes, the table has indexes. And the developer noticed that her program > gets slower as the table grows. Logically queries on a table with 10 > record will be faster than queries on the same table with 1 000 000 > records, but she monitors the program, and says that it drastically > slows down, and which is why I was thinking of update stats. > > >Table gets dropped, created with indexes, loaded, read...? Sounds like a >recipe for pain. Now you realize my pain :-) sending to informix-list