There is a perfomance problem on the function simplenews_user_is_subscribed, because there is no index on mail colunm of simplenews_subcribers table.

Attached the patch to solve the problem.

CommentFileSizeAuthor
#1 simplenews.177955.patch1.45 KBsutharsan
simplenews.install.update3.addedindexonmailsubscribers.patch876 bytesbeppause

Comments

sutharsan’s picture

sutharsan commented
StatusFileSize
new simplenews.177955.patch1.45 KB

Thanks for your contibution. I have added the key to the tables so new installs will also benefit from your works.
I will commit it after testing.

sutharsan’s picture

sutharsan commented
Status: Reviewed & tested by the community » Fixed

Patch committed to HEAD and 5.x-1.x-dev

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.