Den 2011-06-08 14:09 skrev c80840 såhär:

> I have my doubts if the 200GB quote is really true... maybe 200MB, if
> that, more likely 20MB. I worked on one system, a Tandem, where one
> table was over 144 partitions, and the Tandem is considered a
> MAINFRAME/MIDFRAME computer, at the time. The MAX that could be put into
> this table was 576GB, and that was filling it up. Most of the table
> partitions had 25-45% free space, and grew maybe 2% a day. But once the
> partition was compressed (space reclaimed), it would average to about
> 0.25%-0.5% per day, if that. That is about 3GB.
>
> Remember, this was a MAINFRAME/MIDFRAME computer used by one of the top
> 12 insurance companies in the USA. At 200GB, assuming the post is even
> remotely true, means, that depending on the computer and the size of the
> HDD, a new drive would have to be added every 1 to 2 weeks.
>
> So, as stated, I have my doubts that the figure of 200GB is really true.

Fwiw, the poster didn't say that 200 Gbyte was added daily, but that the
transaction traffic was 200 Gbyte. I assume he means that the sum of
select data, insert data, update data and delete data is 200 Gbyte/day,
possibly excluding selects. Even if 200 Gbyte is added daily, perhaps
197 Gbyte is deleted, resulting in a net growth of 3 Gbyte/day.

This is not unreasonable.

I also note that we have a regular poster here who has a system with 200
transactions/second. If they were to "handle" about 12 kbyte each, it
would give about 200 gbyte/day. 12 kbyte/trans isn't much, is it?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64