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

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)