Performance optimisation on command buildqueue

in2code-de / luxletter

Newsletter system for TYPO3

https://www.in2code.de/agentur/typo3-extensions/luxletter/

22 stars 25 forks source link

Performance optimisation on command buildqueue #218

Closed stephane-fillion closed 3 months ago

stephane-fillion commented 4 months ago

new index
prepared parameter on query
database insertion batch

stephane-fillion commented 4 months ago

Hi,

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

Maybe you are interested?

Regards Stéphane

einpraegsam commented 4 months ago

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 commented 3 months ago

So, I tend to close this PR for now