phplist

NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1


View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015318phplist applicationBounce Managementpublic03-08-09 13:3719-04-10 20:50
Reporterrobharrigan 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version2.10.2 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015318: Index needed on phplist_user_message_bounce table
DescriptionI've been experiencing some painfully slow processing time using
processbounces, I suspected it was due to a missing index and the large size
of the table (50000+ records). My response time improved dramatically,
finishing in 2 minutes instead of 6-8 hours, after adding another index to
the phplist_user_bounce_message table like so:

mysql> create index message_lookup using btree on
phplist_user_message_bounce (message);
TagsNo tags attached.
Attached Files

- Relationships
related to 0015417resolvedmichiel speed up bounce management by optimizing mysql tables and queries to use indices 

-  Notes
(0050938)
michiel (manager)
19-04-10 20:50

the index already existed in the structure file, so new installs would get this, but I've added it to the upgrade code to be created, so that it'll apply to existing installs as well


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker