search

dysath / seat-fitting

A Fitting/Doctrine module for SeAT
GNU General Public License v2.0
14 stars 22 forks source link

Setting Doctrine Report Queue Priority #39

Closed MokeyII closed 5 years ago

MokeyII commented 5 years ago

Is there a way to set the job priority for doctrine reports so it runs in front of queues?

As it is right now, If you run the doctrine report, you have to wait for the job queue to finish/reach the report.

is there a way to set this to High Priority rather than waiting for 30k jobs to pass through the queue?

dysath commented 5 years ago

I'm honestly not sure. I'll have to dig into it and see if I can bump it up.

On Fri, Aug 23, 2019 at 1:16 AM Mokey notifications@github.com wrote:

Is there a way to set the job priority for doctrine reports so it runs in front of queues?

As it is right now, If you run the doctrine report, you have to wait for the job queue to finish/reach the report.

is there a way to set this to High Priority rather than waiting for 30k jobs to pass through the queue?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dysath/seat-fitting/issues/39?email_source=notifications&email_token=AEAXRDEVRZN6YDFEWJ54YGDQF56DLA5CNFSM4IO4BQ4KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HG6SZAQ, or mute the thread https://github.com/notifications/unsubscribe-auth/AEAXRDDGLR6VGJM2JSFZ7PLQF56DLANCNFSM4IO4BQ4A .

-- Ed Stafford

MokeyII commented 5 years ago

Thank you for looking into it.

dysath commented 5 years ago

Ok, it's been some a few months since I looked at this project, so I answered incorrectly.

There's no job that runs for the doctrine report. It's a very hard-hitting page that takes some time to resolve if you have hundreds/thousands of people. It's a real-time set of queries, so it's likely taking a good bit of CPU to run it.

So, at the moment, there's no way of improving the speed of the report. I will be taking a closer eye into it once I have some access to a larger corp/alliance installation.