Community > Answers

How can we help you today?

Ask Question
Manage notifications
Subscribe to this question
50 views

Mechanism to prune versions

I don't see an existing SPROC or Function so am wondering if anyone could supply a query that will prune the LiveArticles_Article_Version table to delete all old versions of articles in this table. What I have is an installation where hundreds of articles are published as "finals" and will never need rollback. Yes, the version history setting can be changed from five to one, but old versions are only deleted if the corresponding article is re-saved.

This is also something that will be useful for other Mandeeps modules as well. It's common practice to prune these sorts of tables when wanting to perform content maintenance and improve performance.

Any starter sql would be appreciated.

 

eswanzey eswanzey
asked 12/02/2019 01:10

endorsed by
  • Bryan Tangren
Add Comment
Last Activity 12/05/2019 16:33

1 Answer(s)

  • answered 12/05/2019 10:51
    Ashish Pachori

    You may use the following query to delete ALL older versions (not current) of ALL articles and its pages.

     

    DELETE u1 FROM LiveArticles_Article_Version u1, LiveArticles_Article_Version u2 WHERE u1.Version < u2.Version AND u1.ArticleID = u2.ArticleID

    DELETE p1 FROM LiveArticles_Article_Version_Page p1, LiveArticles_Article_Version_Page p2 WHERE p1.Version < p2.Version AND p1.ArticleID=p2.ArticleID AND p1.PageID=p2.PageID

     

    Important: We don't support or recommend running SQL Queries directly unless you're familiar with SQL and its capabilities. Always have a complete backup of your site before any direct manipulation


     

    Add Comment
    Mariette Knap
    replied 12/05/2019 16:33

    Thanks. This is a great help keeping the database smaller

    Reply
Add an Answer