Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] List of blocked domains is too large and saved in an option that is autoloaded which slows down your site #352

Open
jmslbam opened this issue Feb 21, 2023 · 1 comment
Assignees

Comments

@jmslbam
Copy link

jmslbam commented Feb 21, 2023

Hi all!

After importing the recommended settings a site becomes slow because the autoloaded options will grow with 2MB.
I have had this kind of problem with other sites that stored to much of their data in an option.

To Reproduce
Steps to reproduce the behavior:

  1. Go to MySQL and check the sizes of the zero-spam-settings options that is Autoloaded.
  2. Go to Use Blocked Email Domains Recommendation and import recommendations
    image
  3. Go to MySQL and check the size again. Mine grew by 2.1MB, yupp that's right 2.1MB extra on every load from the Database.

Expected behavior
I expect this large of amount of data not te be autoloaded and to be saved in a separated table.

screenshots
Screenshot 2023-02-21 at 00 07 29
Screenshot 2023-02-21 at 00 25 42
Screenshot 2023-02-21 at 00 25 27

After
image

@bmarshall511
Copy link
Collaborator

Thanks for bringing this to our attention @jmslbam. This problem is a little more complex to fix, but do have plans to rework the settings system to avoid this. I'll leave this issue open until that has been done.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants