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

Add GeneralConfig item to limit `queue/get-job-info` (improve queue performance in the CP) #4533

Open
dsmrt opened this issue Jul 11, 2019 · 0 comments

Comments

Projects
None yet
2 participants
@dsmrt
Copy link

commented Jul 11, 2019

Description

We utilize the queue heavily. On one site I loaded 200k+ jobs which severely impacted the control panel to the point where it was taking 30-60 seconds to load a page in the backend. For environment background and configuration:

On this install, we have separate worker containers for the queue (separate from the web app containers, so they are isolated) and runQueueAutomatically turned off.
(Ref: #4419 (comment) )

As suggested by @gtettelaar (#4419 (comment)), it would be nice to be able manage query limits for queue/get-job-info. Possibly even set it to zero, because we really don't use that.

Steps to reproduce

  1. Load 20k+ jobs into the queue
  2. Load a page in the control panel

Additional info

  • Craft version: 3.1, 3.2
  • PHP version: php 7.2
  • Database driver & version: mysql 5.7
  • Plugins & versions: n/a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.