You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have noticed a pattern during startup of sites with a large number of suggestions that a database CPU spike will occur which sometimes will cause timeouts.
Purging the suggestions manually will remove the CPU spike and normal operations will resume.
I haven't dug into any code yet but my gut feeling is that something cause the plugin to start fetching all suggesions during the startup, maybe this is by design to have a hashset of urls available in the the memory to speed up 404-handling? or is this an actual bug/ unexpected side-effect? Any setting to limit the number of suggestions loaded during startup?
The admin UI handles the large number of suggestions with ease by using pagination so the issue mainly affects the site startup only.
The text was updated successfully, but these errors were encountered:
Hi
I have noticed a pattern during startup of sites with a large number of suggestions that a database CPU spike will occur which sometimes will cause timeouts.
Purging the suggestions manually will remove the CPU spike and normal operations will resume.
I haven't dug into any code yet but my gut feeling is that something cause the plugin to start fetching all suggesions during the startup, maybe this is by design to have a hashset of urls available in the the memory to speed up 404-handling? or is this an actual bug/ unexpected side-effect? Any setting to limit the number of suggestions loaded during startup?
The admin UI handles the large number of suggestions with ease by using pagination so the issue mainly affects the site startup only.
The text was updated successfully, but these errors were encountered: