View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0019703 | phpList 3 application | Statistics | public | 14-01-19 14:28 | 24-01-19 17:06 |
Reporter | Assigned To | ||||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | new | Resolution | open | ||
Platform | Linux | OS | Fedora | OS Version | 26 |
Product Version | 3.3.8 | ||||
Target Version | next major | ||||
Summary | 0019703: User clicks page loads slowly for larger datasets | ||||
Description | Using the phpList demo database, the page loads very slowly (e.g. /lists/admin/?page=userclicks&msgid=2) showing 21,663 subscribers and 43,444 clicks. Consider reducing default page size (currently 100) or optimising the SQL query for performance. | ||||
Tags | No tags attached. | ||||
|
Statistics loads fine for me! It's the DASHBOARD that is incredibly slug-slow ( TEN SECONDS!!!) - and it was nearly instantaneous in V3.3.3 ( just upgraded today to 3.3.8) We have 24,000 users, six lists and about 150 campaigns in the db ... |
|
@randomuser That's helpful, thanks. Is it the whole page, or the AJAX widgets that take time to load? Is there one widget in particular that is so slow? |
|
I'm not super-familiar with the browser console thingy, so I'm not really sure how to determine load times to "widget-level". Looking at the waterfall, it indicates that the browser is basically IDLE for 15 seconds before finally rendering the page. My wild guess would be maybe a very long database query?? The page load sequence 'hangs' noticeably a couple of times, first at 897mS for about 7 seconds, then again at 9325mS for almost 6 seconds... see attached |