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|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|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