Huge number of avia records in wp_postmeta table

Hey profumopuntoit,

Thank you for the inquiry.

That seems to be normal. Please note that the each post or page that is built using the ALB can have at least 3 meta info attached to it. These includes the _avia_builder_shortcode_tree, _aviaLayoutBuilder_active, _avia_sc_parser_state and _aviaLayoutBuilderCleanData, so with that number of posts/pages, the database could easily contain thousands of meta entries. The theme also creates meta entries for menu items.

Do you have a staging or development version of the site? Please post the site details in the private field so that we can check it.

Best regards,
Ismael

Hey!

Thank you for the update.

SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘%avia%’
returns 4371 records

As we have said previously, there are at least 3 or 4 meta entries attached to each post or page and since you have a total of 700++ posts or more, you have to expect that there will be more than 3000++ meta entries just for these items alone. Not to mention the meta entries for menu items and other options. Are you having issue with the site speed or database queries?

SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘%avia%’ AND meta_value =”;
returns 2449 records. Can they be deleted?

Some of the entries with the blank meta_value are created for the menu items. You will find entries like this when you actually run that query.

 146 => 
  (object) array(
     'meta_id' => '1262',
     'post_id' => '3228',
     'meta_key' => '_menu-item-avia-style',
     'meta_value' => '',
  ),
  147 => 
  (object) array(
     'meta_id' => '1272',
     'post_id' => '3229',
     'meta_key' => '_menu-item-avia-division',
     'meta_value' => '',
  ),

This allows the theme to properly structure the mega menu and apply the appropriate menu styles, so deleting those entries will directly affect the site.

Regards,
Ismael

Hi,

Glad Ismael could help! Let us know if you have any other questions and enjoy your weekend :)

Best regards,
Yigit