Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #1183420

    Hi,
    Our website is running slow. When I evaluated I concluded that the autopoaded from _option is very big.
    When running 1 querry I found the following tables are huge

    aviaAsset_avia-head-scripts 31176257
    aviaAsset_avia-footer-scripts 5751650
    aviaAsset_css_filecontent 509679
    aviaAsset_js_filecontent 227916

    This aviaAsset_avia-head-scripts has 31mb.
    what should I do?

    • This topic was modified 4 years, 10 months ago by emanar.
    #1183725

    I am also having this same issue!!

    When I looked at the aviaAsset_avia-head-scripts option value, it was filled with 7 megabytes of
    s:21:\"error-generating-file\";s:66:\"avia-head-scripts-593c1b88ec833ab2d... repeated

    I ran this query monitor plugin https://wordpress.org/plugins/query-monitor/
    and noticed that WordPress was running a massive update script on every page load to set this massive 7mb value.
    This was why my site was running slow.

    I updated to the latest Enfold theme (4.7.3) and cleared out the aviaAsset_avia-head-scripts value in the wp_options table.
    This brought my website back to full speed, but the aviaAsset_avia-head-scripts value is slowly filling back up with the same error, so I believe I’ve only temporarily fixed the issue.

    • This reply was modified 4 years, 10 months ago by AWebDeveloper.
    #1184030

    I just find out that if you turn off this features under performance solves the issue :).
    – CSS file merging and compression /
    – Javascript file merging and compression
    – Http security level for checking readability of merged files

    I thought this features should improve performance.
    Its a bug?

    #1184373

    Hi,

    Thank you for the inquiry.

    Are you using Memcached for your database, or fetching cached data from it? The compression has issues with this method because it returns a database entry with an old timestamp, so the theme doesn’t know the merged files already exist and generates them repeatedly. There is an available filter that you can use to remove this timestamp and prevent duplication of compressed files.

    /* 
     * Some server configurations seem to cache WP options and do not return changed options - so we generate a new file again and again
     * This filter allows to return the same value (or a custom value) for each file. "---" is added to seperate and identify as added value.
     * Return empty string to avoid adding.
     * 
     * The following snippet shows what to return.
     * 
     * @since 4.7.2.1
     * @param string $uniqid
     * @param array $data
     * @param WP_Scripts $enqueued
     * @param string $file_group_name
     * @param array $conditions
     * @return string				
     */
    function avf_custom_merged_files_unique_id( $uniqid, $file_type, $data, $enqueued, $file_group_name, $conditions )
    {
    	return '';
    }
    
    add_filter( 'avf_merged_files_unique_id', 'avf_custom_merged_files_unique_id', 10, 6 );
    

    If this doesn’t work, please disable the compression completely and use an extension like Autoptimize instead.
    Best regards,
    Ismael

    #1191261

    I have been seeing the same issue since 4.7.3.

    Were there changes in the caching algorithm?

    • This reply was modified 4 years, 9 months ago by Jason.
    #1191499

    Hi,

    What do you mean by caching algorithm? Did you enable database caching in your server? The database cache causes the file compression feature of the theme to break and in order to fix it, you have to add the filter above to remove the timestamp and prevent the theme from redundantly generating the merged files.

    If you need further help or info, please create a new thread and post the necessary details in the private field. We’ll close this one for now.

    Best regards,
    Ismael

Viewing 6 posts - 1 through 6 (of 6 total)
  • The topic ‘Cleanup wp_options Table – aviaAsset_avia-head-scripts’ is closed to new replies.