#6344 - SQL bottleneck on stats table

Identifier	#6344
Issue type	Minor issue (breaks specific functionality)
Title	SQL bottleneck on stats table
Status	Completed
Handling member	PDStig
Version	11 beta8
Addon	stats
Description	When a site receives a substantial amount of traffic, and the stats table contains millions of records, then certain queries take 1+ seconds to run (causing a bottleneck and high CPU use): Querying for a member's browser Querying for tracking codes by session
Funded?	No
Commits	Speed up stats table with member_id index (3c4de849) · Commits · Composr ecosystem / Composr · GitLab Optimise stats indexes even more (9e947bbb) · Commits · Composr ecosystem / Composr · GitLab We need an ip_date_time index (423832f3) · Commits · Composr ecosystem / Composr · GitLab

Edited 7th Mar 2026

The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Unrated

Comments

By PDStig, By PDStig, posted 7th Mar 2026, 2:05 PM

The details or status of this tracker issue were updated by PDStig

By PDStig posted 7th Mar 2026, 2:07 PM

On the server running composr.app (8 cores), this fix reduced the average CPU load for ~120 visitors within a session period from 4-5 to about 1.4.

By PDStig, By PDStig, posted 7th Mar 2026, 2:26 PM

The details or status of this tracker issue were updated by PDStig

By PDStig posted 7th Mar 2026, 2:26 PM

This also makes the "investigate user" (by IP address) tool much faster. Nice!