View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0015318 | phpList 3 application | Bounce Management | public | 03-08-09 13:37 | 19-04-10 20:50 |
Reporter | robharrigan | Assigned To | |||
Priority | normal | Severity | major | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 2.10.2 | ||||
Target Version | 2.10.12 | Fixed in Version | 2.10.12 | ||
Summary | 0015318: Index needed on phplist_user_message_bounce table | ||||
Description | I'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); | ||||
Tags | No tags attached. | ||||