Large Versioning and DB Space problem

5 months 6 hours ago - 4 months 4 weeks ago #79622 by grabit
Hi,

I have a problem with my DB: versioning was set to 10 versions and now the flexicontent_items_versions table is huge (more that 300mb).

Even if I remove the versioning, the table is still there and doesn't shrink.

How can I reduce the size of that table as my hosting company ask me to come to a lower size?

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

4 months 4 weeks ago - 4 months 4 weeks ago #79623 by ggppdk
Hello

the simplest solution would be to empty ALL version data,
Truncating 2 tables (if truncate both then there will not be any problems):
TRUNCATE flexicontent_items_versions;
TRUNCATE flexicontent_versions;

To keep newest versions and delete old , you would probably need a procedural query that i do not know out of my head


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.