OK, I'm been making changes to a site which I have now finished, but we are running into issues with quite a large database (about 270Mb).
I wonder if it might be to do with the fact that I was intending to copy the home page alone and accidentally copied all its child documents as well. I deleted them, but I am wondering if them are still around.
However, there aren't [i]that[/i] many pages in the site, and I'm quite surprised that this would have such an effect.
But anyway, the database is too large at this point and I need to deal with it without breaking the site.
I have access to the database through a web based interface.
Personally, I would truncate the umbracoLog table if you're not concerned about losing audit trail data. I regularly do this for clients who don't have audit trail requirements to keep the database relatively lean.
Questions about dealing with large database
OK, I'm been making changes to a site which I have now finished, but we are running into issues with quite a large database (about 270Mb).
I wonder if it might be to do with the fact that I was intending to copy the home page alone and accidentally copied all its child documents as well. I deleted them, but I am wondering if them are still around.
However, there aren't [i]that[/i] many pages in the site, and I'm quite surprised that this would have such an effect.
But anyway, the database is too large at this point and I need to deal with it without breaking the site.
I have access to the database through a web based interface.
The largest tables are :
cmsContent - 951 rows
cmsContentVersion - 2147 rows
cmsDocument - 1876
cmsPreviewXml - 1664 rows
cmsPropertyData - 48759 rows
umbracoLog - 275897 rows
umbracoNode - 1058 rows
So yes, I need to get it below 200Mb.
I'd appreciate any assistance with this matter.
Thanks in advance.
Hi,
Personally, I would truncate the umbracoLog table if you're not concerned about losing audit trail data. I regularly do this for clients who don't have audit trail requirements to keep the database relatively lean.
HTH
Hi,
How about the F.A.L.M Housekeeping package - can selectively clear the log and delete old document versions.
F.A.L.M Housekeeping package is great thanks, just knocked 100mg of my database.... I might even trim it more :)
is working on a reply...