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:owner-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: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
sending to informix-list