View Issue Details

IDProjectCategoryView StatusLast Update
0019703phpList 3 applicationStatisticspublic24-01-19 17:06
ReportersamtukeAssigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
PlatformLinuxOSFedoraOS Version26
Product Version3.3.8 
Target Versionnext major 
Summary0019703: User clicks page loads slowly for larger datasets
DescriptionUsing 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.
TagsNo tags attached.



23-01-19 23:01

reporter   ~0061777

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 ...


24-01-19 11:05

manager   ~0061779

@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?


24-01-19 17:06

reporter   ~0061784

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
phplist-slow03.png (45,610 bytes)   
phplist-slow03.png (45,610 bytes)   
phplist-slow02.png (66,491 bytes)   
phplist-slow02.png (66,491 bytes)   
phplist-slow01.png (80,557 bytes)   
phplist-slow01.png (80,557 bytes)