SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 07:23 AM
| ||||
| ||||
 RE: Running 4GL on table that changes a lot Dirk, Why not issue the update statistics command from within the 4GL program? After all UPDATE STATISTICS is only an SQL statement. And if you use UPDATE STATISTICS FOR tablename it should not take too long. The other thing you should do is to SET EXPLAIN ON in the 4GL program and look at how it optimizes the query. That should point you in the right direction. Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto  wner-informix-list@iiug.org]On Behalf Of Dirk Moolman Sent: 11 January 2005 16:53 To: informix-list@iiug.org; Obnoxio The Chav Subject: RE: Running 4GL on table that changes a lot -----Original Message----- From: Obnoxio The Chav [mailto bnoxio@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 sending to informix-list      |
Linear Mode
