RE: Running 4GL on table that changes a lot

-----Original Message----- From: Obnoxio The Chav [mailto:obnoxio@serendipita.com] Sent: 11 January 2005 04:17 PM To: Dirk Moolman Cc: informix-list@iiug.org Subject: Re: Running 4GL on table that changes a lot Dirk Moolman said: > > I think this is in the CDI archives, but I haven't found it yet. If > memory serves me right, it was discussed on this list some years ago. > > Some of our programs run batch processes, dropping & creating tables, > and then inserting lots of records into them ... BUT, and this is my > problem, the program also reads from the tables being inserted into. > > Because these tables are recreated, no (update) statistics exist on > them. But I also can't create them, run update stats and then read from > them - the reading and inserting happens at the same time. > > How do I overcome this problem ? Hope my question is clear enough. >Well, let's start again: do these tables have any indexes? If not, what >difference will an update stats make? What is the actual problem that you >think update stats will fix? 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. sending to informix-list