Do those removed attachments get deleted? I tried backing up the database before and after. I don’t see the file size reduced much
1 Like
This is due to how SQLite is working. When you delete an attachment, SQLite database doesn’t decrease in size but the space in the database will be allocated to future data (or attachments).
There is VACUUM command which can be run on any SQLite database to manually shrink it.
Dear lubos,
could you kindly advise the Syntax of the VACUUM command line and database file name in command line for VACUUM? is it “business name”.manager?
Having the same problem here
I don’t believe this should be an issue. If I remember correctly, this function now occurs automatically.
I have an issue if the transaction is deleted without deleting the attachment. The file size remains the same, giving me the impression that attachment was not deleted. Any way it can be deleted?
Don’t double-post your questions.
Dear team.
I do not understand how to make my file smaller with Vacuum command. I follow your link but that computer language is not in my accounting vocabulary. Can you please assist?
We uploaded attachments, but when I delete it, the file size remained the same. I want to shrink my Template File, otherwise I have to do all the changes / reports I created/ COA all over again in a new file to get a smaller template file. Otherwise, can I please email my Template file to someone with more computer knowledge who can shrink it for me?
I am on the online package, but I keep backups of my client files, and it will take too much space on my computer and it takes too long to download because it is too big.
Regards
Petrie
@Petrie_Fuls this is old topic. Here is the guide how to shrink your database:
1 Like
Oh my. So easy. Thanks a lot. I can’t believe I missed that guide.
Don’t forget there is a Search capability for the Guides: Search the Guides | Manager. It works quite well. Because it searches the full text of the Guides, it will almost always turn up what you want.
hello, sorry if I reply this old thread.
but I deleted many attachments, from 500 to 120 and the file dimension is not reduced.
naturally I clicked on the file size (like the guide Reduce data file size | Manager), but didn’t worked. I think it’s strange because I used this feature in past and worked fine.
although the current 120 attachments could be very large… I think it should less than only 1MB (it was 48 and now 47).
Your file size was reduced. That proves the feature worked.
Also, the Undo feature for managing the History file means that the files are not really removed. If you Undo the deletion, they will reappear.
If you really want to get rid of the files, you will need to make a backup of your program without attachments and without the History file. But this process is not selective.
I kept the original business, I exported it and now I’m working on the imported.
The orginal file is 48MB, and the imported, after deleted many attachments (many of them also bigger than 1MB) is 47MB.
I think is strange because if I deleted several attchments with more than 1MB each file, the size of the business should be less than 47MB.
Anyway, I will try to backup without attachments.
You also have to backup without History. (I edited my previous post to include this statement.)
It taken long time, but I completed.
There was something that don’t work, I’ve exported/imported without attachments, then added the needed attachments. Now I’ve a size of 8MB instead of 47MB.