godaddy-wordpress / godaddy-wordpress/wc-plugin-framework

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

Open
#672 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
146
Forks
43
Avg merge
21m
Merged PRs (30d)
3

Description

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

the create_job ( https://github.com/godaddy-wordpress/wc-plugin-framework/blob/1c2fb1a31228f754ef7427f15ac034d3d8cb6de0/woocommerce/utilities/class-sv-wp-background-job-handler.php#L391 )

and
get_job ( https://github.com/godaddy-wordpress/wc-plugin-framework/blob/1c2fb1a31228f754ef7427f15ac034d3d8cb6de0/woocommerce/utilities/class-sv-wp-background-job-handler.php#L391 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)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.