Re: Database-Size
Posted: Wed Jun 06, 2012 10:20 am
I would like some clarification on this topic and none of the replies seems to actually answer the original query.
i.e. How does one reduce the database file size after emptying the Trash.
Our database file is now ~1.3GB. Several weeks ago I tidied up by deleting all the 'Sent' applications older than one month (we export them as soon as they are sent but people are reluctant to delete them immediately).
I also emptied the 'Trash' folder.
I had hoped that at some point the database would be automatically purged/compressed but this hasn't yet happened and it appears that I may have to do it manually.
Although I have frequently seen the advice that eOLF should not be used to archive 'Sent' filings, this is rather irrelevant if deleted applications are never removed from the database.
It is possible that the information I want was available under another thread but the link in Yves post is now broken and it would appear that the thread he refers to has been deleted.
Could someone clarify whether the database is automatically purged and when or under what circumstnaces this happens.
It would also be useful if this thread explained how to do this manually.
Thanks
Matt
i.e. How does one reduce the database file size after emptying the Trash.
Our database file is now ~1.3GB. Several weeks ago I tidied up by deleting all the 'Sent' applications older than one month (we export them as soon as they are sent but people are reluctant to delete them immediately).
I also emptied the 'Trash' folder.
I had hoped that at some point the database would be automatically purged/compressed but this hasn't yet happened and it appears that I may have to do it manually.
Although I have frequently seen the advice that eOLF should not be used to archive 'Sent' filings, this is rather irrelevant if deleted applications are never removed from the database.
It is possible that the information I want was available under another thread but the link in Yves post is now broken and it would appear that the thread he refers to has been deleted.
Could someone clarify whether the database is automatically purged and when or under what circumstnaces this happens.
It would also be useful if this thread explained how to do this manually.
Thanks
Matt