[Koha] Truncate deletedbiblio, -biblioitems, -items tables?

[Zeno Tajoli]

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 @)