by Damiaan Peeters
28. November 2015 01:24
I just got a production database. This database was massive. One of the big tables was the cmsPreviewXml.
To clean up the Umbraco cmsPreviewXml run the SQL script below. This will delete all older previews, but keep the most recent.
select *
--delete
from cmsPreviewXml
where versionId in (
select cmsPreviewXml.versionId
from cmsPreviewXml join cmsDocument on cmsPreviewXml.versionId=cmsDocument.versionId
where cmsDocument.newest <> 1)
The other scripts I used to clean the umbraco database are in this gist: https://gist.github.com/dampee/a8ead728165b16d49c00