We have a database for our openERP that is quite huge. As far as i can see, we have 2 tables that are mostly responsible for that size : EDI_Document and ir_Attachment. Those 2 tables size 7 GB... My question is, is it possible to clean those tables (because we don't need the documents stored in it), and what could be the cleanest way to do it ? is it possible to clean from openERP itself ? can we configure something so those tables won't be filled again ?
I've seen that a module can be used to manage the document ? is it the way i'm looking for , or is it just another way to do the same thing (i.e. cleaning my database of unnecessary documents). What i've understood is that the module just tell that the documents are stored in a directory and no more in the database, which would be better than the present configuration...
Thanks in advance for your help regards
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/30/13, 11:30 AM|
|Seen: 1222 times|
|Last updated: 3/16/15, 8:10 AM|