How to reduce size table jbuilder_revisions

yfb01

Hi,
I noticed that the table jabuilder_revisions is taking a lot of space (about 16Mo).
How can I reduce its size? (I modified the number of histery versions to keep in the plugin, but it doesn't have any impact on the size of the table).
Regards
yves

Ninja

yfb01
Hi
Can you share the screenshot from your DB tables ? as i can not see this table in my builder installation.

The version are use to save all changes you make during the page edit.

yfb01

Hi,
enclosed 3 print screens:
- the table name + size
- the table structure
- example of one record

Ninja

yfb01
Hi
it contains all the save block code for all pages or your site, deleting the table will make it empty all records.
You can not reduce the size as it depend on the changes you making, you can delete the entries once your pages complete, i too test builder but no having this big size, maybe you have too much versions present on site.

Regards

yfb01

Hi,
I followed the "normal" procedure to do the updates. How can I remove the previous versions?
Enclosed if the print out of the ja builder elements (via the Manage menu). they all refer to the same package id.

Ninja

yfb01
Hi
You already have the latest version, Once you install the new builder it means it auto override the previous version.
if you want to remove everything you need to deleted all builder DB data and other things.
Deletion will also delete the builder pages.

Regards

yfb01

Hi,
I come back to you because the jabuilder_revisions table is now about 35 Mb.
You said that if I empty the table, then I will loose the pages.
But how is it possible to empty all the old history info as I don't want to go back in time for most of the pages or up to a certain date?
Regards
yves

Ninja

yfb01
Hi
Revision of the page is for your changes so all the changes you will make , it will save them in the DB and you can revert to that if required.
Let me check with Dev on Monday for deletion of the Revision part.

yfb01

Hi Ninja

Do you have any news about it?
Regards
yves

Ninja

yfb01
Hi
Our development team accepted tge request and we will add an option inside the Builder that will allow you to delete/clear the version, this will help you to clean the DB directly via edot page. No need to drop the tables.

yfb01

Hi Pankaj,
do you have an idea when that option is to be added in the builder (on T3)?
regards
yves

Ninja

yfb01
Hi
In JA Builder you will get an option to delete each revision versions one by one, you can keep a version you want and delete the ones you want to delete.
I will keep you posted once it added and released.

yfb01

Hi,

do you still plan it for 2020 or for which decade or century?

Ninja

HI yfb01
its planned to add with more updates i builder. i added a reminder for Dev team on this to give solution as soon as possible.

yfb01

Hi,

when is the "possible"for you.
you are late on all the tickets premium or not.
I don't think it is useful for people to buy a support when we are obliged to wait for months on the various tickets.

Ninja

yfb01
Hi
Its already released. Kindly update builder to latest version.
You will see the option on backend > edit a builder menu via JA Builder to see Revision Manager tab