I was just hunting around in the wiki for an SQL query to remove old cruft from the database and found this:
https://github.com/bricoleurs/bricolage/wiki/Useful-SQL
… has anyone tried that on a recent version of Bricolage?
Specifically, the database in question is full of wire service stories, and each story has up to 50 versions stored. There are more than 10,000 of them, which is a sizeable percentage of the total number of stories in the system, and I can't help but think that permanently deleting them, along with their version, would reduce the size of the database and possibly improve performance.
Thoughts on the above and how to achieve both the deletion of the stories, and their version, and so on? Does anyone know if there's a "cascade on delete" that's going to run and handle all of that if I run the above SQL?
Many thanks in advance,
Phillip.
--
Phillip Smith
http://phillipadsmith.com
https://github.com/bricoleurs/bricolage/wiki/Useful-SQL
… has anyone tried that on a recent version of Bricolage?
Specifically, the database in question is full of wire service stories, and each story has up to 50 versions stored. There are more than 10,000 of them, which is a sizeable percentage of the total number of stories in the system, and I can't help but think that permanently deleting them, along with their version, would reduce the size of the database and possibly improve performance.
Thoughts on the above and how to achieve both the deletion of the stories, and their version, and so on? Does anyone know if there's a "cascade on delete" that's going to run and handle all of that if I run the above SQL?
Many thanks in advance,
Phillip.
--
Phillip Smith
http://phillipadsmith.com