ADSM-L

Unload/load db and long expirary

2002-09-03 08:51:31
Subject: Unload/load db and long expirary
From: Rodney clark <Rodney.Clark AT INGBANK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 2 Sep 2002 09:15:00 +0200
Just a quick heads up,

We had been struggling with a really slow expirary process on a 33 gbyte
database.
Typically the process would delete inspect abount 30 or 50 objects a second.
Expirary was inspecting about a million objects a day.
No good a client was archiving a million objects a day.

On the weekend we did a unload load ( the second this year ) bingo we are now
inspecting objects about 300 to 400 per second incidentally, most of the objects
are being deleted.

The database went from 70% usage to 50%.

Lets just hoop it stays this way.
Server is 4.2.1.11


-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------

<Prev in Thread] Current Thread [Next in Thread>