I have about 20 pages using “Page Builder” each off them has about 20 “areas”
I noticed that there was to much records in the database
running this query
SELECT count(*), meta_key,`post_id` FROM wp_postmeta group by `meta_key`,`post_id`
having `meta_key` like ‘panels_data’
ORDER BY count(*) DESC
it returns ….
count(*) meta_key post_id
3300 panels_data 480
2264 panels_data 1049
2189 panels_data 667
1599 panels_data 633
1532 panels_data 676
1342 panels_data 501
1276 panels_data 1092
1267 panels_data 512
1229 panels_data 517
these pages are daily updated …..but I have cleaned revisions with the plugin “Better Delete Revision” and still have this amount of “garbage”
sorry . wrong url
this one is correct
URL: http://vitorbaiameteo.pt/localidades/guarda/
Hi Fmmribeiro
Thanks for reporting this challenge.
We took a look now. This is the nature of the WordPress core post_meta API we’re using. As it stands, we don’t yet see a way of a changing this behaviour.
Sorry we don’t have more on this. I haven’t used Better Delete Revision. Can you perhaps automate the process?
HIAndrew Misplon
Do you mean that if I update one page again that has 10 regions/content I will have +10records in the wp_postmeta table?
How to Can you perhaps automate the process?— can you explain
Page Builder only uses a single post meta for the entire page. Is that not what you’re seeing?
hello Andrew
I can send you the database so you can run the SQL command above if you wish
Apologies for the delay. Sure, if you could send that through to Private Snippet that’ll be great. Greg is away for a few days. I’ll raise your report with him during our first meeting when he’s back.
hello Andrew Misplon
Any updates on the issue?
Sorry, no progress on this yet. I’ll follow-up with Greg as soon as possible tomorrow. Thanks for the wait.
No problem Andrew
best regards
Thanks for your understanding. Will come back to you ASAP.
hello Andrew Misplon and Greg
Do you have any updates on this?
Hi Fmmribeiro
I had a look though the database dump, unfortunately this hasn’t shed any light on your particular issue. Page Builder is just using the standard WordPress post meta API. So we don’t take any control over what’s happening on a database level
https://codex.wordpress.org/Metadata_API
And this is where we’re saving all the Page Builder into a single post meta key called panels_data
https://github.com/siteorigin/siteorigin-panels/blob/develop/siteorigin-panels.php#L559
I’m not sure why this is coming up for you. Perhaps its some sort of plugin conflict or a hosting configuration issue. For now, all I can suggest is that you try a plugin like Cleanup Duplicate Meta to remove the duplicate entries.
https://wordpress.org/plugins/cleanup-duplicate-meta/
thanks Greg Priday
I removed all the revisions and used cleanup meta and now the database dropped from 300mb to 3mb