NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1
|
NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1 |
| Anonymous | Login | Signup for a new account | 23-06-17 04:30 BST |  |
| My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
| 0015318 | phplist application | Bounce Management | public | 03-08-09 14:37 | 19-04-10 21:50 | ||||
| Reporter | robharrigan | ||||||||
| Priority | normal | Severity | major | Reproducibility | always | ||||
| Status | resolved | Resolution | fixed | ||||||
| Platform | OS | OS Version | |||||||
| 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. | ||||||||
| Attached Files | |||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||
|
||||||
 Relationships |
|
Notes |
|
|
(0050938) michiel (manager) 19-04-10 21: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 |
|
Notes |
| Copyright © 2000 - 2017 MantisBT Team |
 |