luxletter icon indicating copy to clipboard operation
luxletter copied to clipboard

Performance optimisation on command buildqueue

Open stephane-fillion opened this issue 1 year ago • 2 comments

  • new index
  • prepared parameter on query
  • database insertion batch

stephane-fillion avatar Apr 09 '24 15:04 stephane-fillion

Hi,

We slightly modified the code for a custom to speed up the buildqueue command.

Maybe you are interested?

Regards Stéphane

stephane-fillion avatar Apr 09 '24 15:04 stephane-fillion

Thx for your PR. Nevertheless, there is another performance feature already implemented in LUXletter. You can turn on asynchronousQueueStorage in extension manager settings. If there are more then 50,000 receivers there is no way to do it synchronous via Apache. Did you test this?

einpraegsam avatar Apr 10 '24 07:04 einpraegsam

So, I tend to close this PR for now

einpraegsam avatar May 13 '24 06:05 einpraegsam