• Resolved dannoll

    (@dannoll)


    Hi,
    I just noticed (perhaps on the latest version update 4.3.1), that my wp_options table is beginning to fill with 1000s of records like “wp_swcfpc_cache_preloader_background_process_batch_….”

    This does not seem right. Is there any way this can be prevented or avoided?

    Again, I did not notice this when the plugin when was first installed and running, only upon one of the more recent updates.

    Thanks,
    Dan
    P.S. I am also using plugins like WP-Rocket, Perfmatters and Asset Cleanup.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    Hi Dan,
    these records are automatically added from WordPress for batch processes like the preloader.

    If you don’t want use the preloader, just disable the option to automatically preload pages purged from Cloudflare, under PRELOADER section.

    Have a nice day! ??

    Thread Starter dannoll

    (@dannoll)

    To confirm my understanding: if I continue to use the preloader, I should expect to see wp_options to fill up with batch process records. Is that correct?

    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    Hi @dannoll ,
    yes and no. The preloader uses the following library:

    https://github.com/deliciousbrains/wp-background-processing/blob/master/classes/wp-background-process.php

    When a new queue (the list of URLs to preload) is created, a new “_batch_” record is added into the wp_options table together with some transient.

    When the queue becomes empty, the library deletes the “_batch_” record (code lines 317-322):

    // Update or delete current batch.
    if ( ! empty( $batch->data ) ) {
    	$this->update( $batch->key, $batch->data );
    } else {
    	$this->delete( $batch->key );
    }

    If you keep seeing those records at the end of preloading, something went wrong with the library. Sometimes I happened to see them disappear on the next preloading task.

    Thread Starter dannoll

    (@dannoll)

    I notice several hundred records for the same post — that is, whose “Option Value” in the wp_options table is exactly the same. Is this expected? NOTE: This occurs for a few posts.

    P.S. Thanks for your prompt replies, and for your work on an excellent plugin.

    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    Hi @dannoll ,
    on 4.3.2 I added a lock system in order to execute only 1 preloader at once. This will save cpu and will add less records in wp_option table.

    I suggest you to update to latest version

    Thread Starter dannoll

    (@dannoll)

    Thank you. I just downloaded it and am running it. I will keep you posted.

    Also — should I assume this plugin update will clean or trash collect the old duplicate records the plugin created in wp_options?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘wp_options table filling with wp_swcfpc_cache_preloader records’ is closed to new replies.