Hello,
I have a test tenant that has grown to 41GB. Does anyone have any experience with optimizing a tenant size.
I have already deleted all old snapshots. The majority of the data are in the Note and UploadFileRevision tables.
Best answer by pallikasharma11
View original
+12
Hi
Can you delete the tables which are not needed and decrease the size?
Did get a chance to review this
The only option I know of is to create a customization project and use a script to delete the notes:
Delete Note where GraphType='KNCFCore.KNCFLogMaint'
Hi
Can you delete the tables which are not needed and decrease the size?
I do not have experience with deleting tables and wanted to see what options I have.
+12
Hi
Can you delete the tables which are not needed and decrease the size?
I do not have experience with deleting tables and wanted to see what options I have.
Hello
Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3
Hello
Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3
Thanks for sharing the help article.
Since the Note is the largest table is there a way to optimize it?
The Note table will most likely require a SQL script. Recommend testing it first
delete top (10000) f
from Note f
where CompanyID = 2
What about using a share drive for attachments (Uploaded Files )….. instead of saving to the Database ?
Hello
Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3
Checked the article. How would I check the notes table?
What about using a share drive for attachments (Uploaded Files )….. instead of saving to the Database ?
Yes that is a good idea. For large attachments like photos or videos we use our server to upload.
Hello
Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3
Checked the article. How would I check the notes table?
I used the Search In Files to find the files that are in the upload. I do not see a way to sort or filter by files size. Is there a way to find what files are the largest?
FYI, I was finally able to fix this issue by adding a database script to delete the data from the notes. Here is a screen shot of the script.
In total about 35 GB of data was removed and the test tenant is no 6.6 GB in size.
Thanks for all the responses.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
