Hi, I find a layout about koha´s architecture. Found a one in http://www.kohadocs.org/Koha_architecture.html but the link refer to 2.x series. Series 3.x too use this layout? Tks Carlos -----Mensagem original----- De: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] Em nome de Zeno Tajoli Enviada em: segunda-feira, 14 de dezembro de 2009 13:04 Para: Richard Pritsky Cc: koha@lists.katipo.co.nz Assunto: Re: [Koha] Truncate deletedbiblio, -biblioitems, -items tables? 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 @) _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha