Hi, At 15.17 14/12/2009, Richard Pritsky wrote:
Since these tables are now taking up about 25% of my database size, are there any critical reasons NOT to truncate them?
in fact is quite strange that 25% of your DB size is connect with deletedbiblio, deletedbiblioitems, deleteditems. Why ? Too much test of import ? The critical poin is your circulation reporting policies. Id in deleted- tables could be connect with some past circ events. As I know you can't deleted a items with an active circ event. So, if you have just done all circ reports, all is OK, you can truncate them. To be sure: --extract all id in deleted- tables --seek if any of them is in historical tables. I suggest you to do this opertation in a DB different of your production DB. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)