0019703: User clicks page loads slowly for larger datasets

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

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

samtuke 24-01-19 11:05 administrator ~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?

randomuser 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)