Dirk Moolman said:
>
> -----Original Message-----
> From: Obnoxio The Chav [mailtobnoxio@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.

Table gets dropped, created with indexes, loaded, read...? Sounds like a
recipe for pain.

--

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my ass"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

You're so stupid, you think martial arts are paintings by a sheriff...

I went to the airport to check in and they asked what I did because I
looked like a terrorist. I said I was a comedian. They said, "Say
something funny then." I told them I had just graduated from flying
school.

-- Ahmed Ahmed
sending to informix-list