Many records in postmeta table

Hey onizet,

Thank you for the inquiry.

The new custom fields are for the posts css file creation for custom element styles, which is supposed to improve the site speed. But if you are having trouble with the database and you believe that these custom fields are causing it, then you can disable it using this filter in the functions.php.

/**
 * Filter to skip css file generation.
 * You can add logic to skip for certain pages/posts only.
 * 
 * @since 4.8.6.1
 * @param boolean $create
 * @return boolean					true | false or anything else to skip generation of css file
 */
function custom_avf_post_css_create_file( $create )
{
	return false;
}

add_filter( 'avf_post_css_create_file', 'custom_avf_post_css_create_file', 10, 1 );

Unfortunately, you cannot disable the other custom fields that we discussed in the previous thread because those fields contain the builder elements or shortcodes.

Best regards,
Ismael

Hi,

Do they have the same meta keys? Using the code above should prevent the theme from creating the _av_css_styles custom fields. You might also want to check entries generated by your plugins including contact forms and analytics.

And if you want to completely remove the existing post css files entries from the database, you can run this query.

DELETE FROM wp_postmeta WHERE meta_key = '_av_css_styles';

Please make sure to create a site backup or a restore point before doing so.

Best regards,
Ismael

Hi,

Thank you for the update.

I notice sometimes files stand in files, sometimes in /sites/x/,

What do you mean? Have you tried disabling the post css files? You can add the code in the functions.php file to prevent the theme from autogenerating those files. This should also decrease the entries in the database. If not, try to delete them manually using the query above. Just make sure to create a database backup before doing so.

Best regards,
Ismael