By Adam O. on Wednesday, 24 August 2016
Posted in Technical Issues
Replies 1
Likes 0
Views 583
Votes 0
Hi there,
I've got updated EB to last version 5.0.37.

Every day my site has about 25-30 new posts and at now, after a few months, in my database, table easyblog_revisions has more than 350 MB.

Site loads slow and I don't know what to do with this case.

Is any way to not store or purge revisions from this table? I know, that EB > 5 is based on revisions, but what in my situation?

Many many many not useful revisions, heavy table > 350 MB and slow page.

I'll be very grateful for your help with this thread.

Best regards
Adam
Hey Adam,

Regarding your site slow issue actually that is not related with those revision data.

And currently we do not have any better solution for this, because now the blog post is rely on the post revision.

I have a question, may i know your existing blogger is it will edit their very old blog post from your site?

If no, you can follow my instruction to reduce a little size from your revision table from database.

Note : before you run this following SQL queries you have to backup all of your existing data first.

Replace #__ to your database table prefix


update `#__easyblog_post` set `revision_id` = 0;


truncate table `#__easyblog_revisions`;


After you done that, try open your Easyblog frontpage, it will regenerate again the post revision in your table.
·
Wednesday, 24 August 2016 11:17
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post