Re: The plugin slows down the site by littering the wp_options table

[ramonfincken]

@see https://wordpress.org/support/topic/the-plugin-slows-down-the-site-by-littering-the-wp_options-table/

the create_job (

wc-plugin-framework/woocommerce/utilities/class-sv-wp-background-job-handler.php

Line 391 in 1c2fb1a

public function create_job( $attrs ) {

)

and
get_job (

wc-plugin-framework/woocommerce/utilities/class-sv-wp-background-job-handler.php

Line 391 in 1c2fb1a

public function create_job( $attrs ) {

0

are really bad for performance as they do not have integer primary keys and use LIKE queries in the option_value's.

It needs to be converted to a dedicated table like this (just an example):

ID (PK, integer or varchar)
identifier (key)
status (key)
created_at (datetime)
created_by (int)
started_processing_at (datetime)
updated_at (datetime)
total (int)
progress (int)
handles (text)
completed_at (datetime)
data (text)