Hi, Any idea what is maximum size of data Manager can work without slowing down in the server and cloud edition. now i am starting to use the server edition, i have entered only a 5% of my backlog of the year and data is showing 10MB, i have not attached any files to the folder.

@ismail there is VACUUM command which you can run on any SQLite database to compact it. What it does, it will free all unused space. Right now, unused space in your SQLite database will get eventually used up by new data but your database size won’t grow until there is no unused space left. I will …

I’m not an expert so my explanation may be imprecise. From what I understand, when you delete something from an SQLite database, the space that was occupied by the deleted item remains as free space in the database. In other words, the database will not shrink after you delete an item from it. To i…

I thought the VACUUM command was run when making a backup. Apparently I am wrong. So forget my suggestion, @ismail . (Although, it costs nothing to try and there is no risk. If the backup isn’t smaller, just delete it.)

@Tut , I thought it would work too, but when I tried there was no difference: [image]

Oh, that’s new thing I learnt thanks friends. @lubos , I will google it to download and run this vacuum. Would be safe if you please suggest a link and steps to run it on manager. So it will be useful for forum until as you said incorporating within manager. ----- Reply message -----

The latest version (17.7.9) will automatically run “VACUUM” upon clicking Backup button.

@lubos This is great, I will check it. Thank you so much. Best Regards ----- Reply message -----

@lubos [image] i am testing this from a desktop version at home, my re-installed version is 17.7.13. i did a backup and imported the same, the size did not reduce still.

Using Desktop version 17.7.13, I also did not see any file size reduction: [image] [image]

I saw no reduction either, in a roughly 6MB test company that has had many attachments added and deleted. File size remained the same right to the single KB. I do notice, however, that the file size shown on the Businesses page for every business is smaller than shown in my operating system’s file …

The Maximum data size Manager works in server & cloud edition

Topic		Replies	Views
Manager Backup File Size	2	206	April 30, 2024
Max size backup	3	870	July 5, 2017
Removed Attachments get deleted?	15	1120	November 17, 2020
Slow loading	24	3639	March 5, 2021
What is the Effect of very large files saved?	3	624	July 20, 2015

The Maximum data size Manager works in server & cloud edition

Related topics