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. -----------------------------------------------------------------