View Issue Detail

ID	Project	Category	Submitted / Last Updated
02160	UserSpice	Triage	2025-08-09 13:33:53 / 2025-08-15 18:59:49
Reported	Tomáš Uchytil	Resolved By	Dan Hoover
Priority	none	Reported	5.9.3
Status	resolved fixed	Resolution Version and Commit	5.9.4
Summary	Change Datatables to server-side processing
Description	Currently, all data is first loaded into browser and then filtered by datatables locally in browser. However, with large tables, this is either very slow or straight up impossible. I suggest switching to async data loading, where all filtration is handled server side, mostly in MySQL database which is optimized for that, which makes it quite a lot faster and less heavy for both throughput and memory. Link to datatables server side processing documentation: https://datatables.net/manual/server-side Affected tables: Mainly "system logs", "security logs" and possibly "users", but likely could be extended to more tables. If you need more info or minimal working example, let me know.

August 2025

I totally agree. I've had this on my todo list for a while.I'm not sure if I'll be able to get it into 5.9.4, but I have this at the top of my list.