Database growth

Hello,
We developed a site for a client using Sitefinity 5.2 a while back. The client has just gotten in touch with us to say that their database seems to be growing at a surprising rate (about 650 megs a week). All of the growth seems to be in one table: dbo.sf_ppvl_tracking_rcrd_df_ppvl_. The site is a pretty small site with a few dozen pages and minor content updates at times. Can anyone tell me how to resolve this?

Greg

Hi,

We have answered you on the support ticket you have opened. I will share this information with the community:

Table sf_pprvl_trckng_rcrd_sf_pprvl_ stores information for each item or page in Sitefintiy and its workflow status whether it is pending approval or it is scheduled, however there was an issue in Sitefinity 5.x versions, the data in this table was not deleted when content or page that entered this data there was deleted.

@Stefani So does 6 retroactivly go back to clear out all the bad entries, or is it iust *new* items that are properly cleared?

Thanks for the help Stefani and for the script.

Can anyone answer Steve's question please?

We've upgraded from 5.4 to 6.2, and our database is still huge. The sf_pprvl_trckng_rcrd_sf_pprvl_  table is over 4GB in size still!!
How do we remove the unnecessary records?

Is there anyway to fix this without having to upgrade to 7?

Is there a way to clear these tables at least? I see mentioned above about a script. 

Hi all,

The following problem connected to some tables which are not updated after items are deleted or which are not used by the items at all:

feedback.telerik.com/.../99575-workflow-related-tables-not-updating-entries-property-after-workflow-items-are-de

Has been resolved in Sitefinity 7.0 version. A permanent fix has been included in the Sitefintiy 7.0 version, where we drop these tables with the upgrade script below. as they will no longer be needed by our logic.

It is recommended to upgrade your project to Sitefinity 7.x in order to prevent this behavior and take advantage of all available fixes and new feature. More information about the upgrade could be found on the following URL.

However, you could test to execute the script below on a backup of your database and see whether the project  would be working properly.

NOTE: before proceeding please verify if CRUD operations are working fine on all Sitefinity content
1. Ensure you have a full database backup before proceeding
2. Execute the following SQL script against the database in SSMS: