+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Pagination is slow? (/showthread.php?tid=90753)
Pagination is slow? - xsPurX - 04-28-2024
Hi,
I ran the pagination system and there is a 1-2 second delay to load my page now. Even though there is only a few records. Where without pagination it loads fast. The development debugger doesn't even show the delay.
Below is the debugger, but there is a delay in loading the page. So any ideas what could cause that? Clearly it;'s loading the data and everything quickly, so,not sure why there is a 1-2 second pause before the page loads.
Code:
Bootstrap Timer 54.04 ms
Routing Timer 1.74 ms
Before Filters Timer 0.07 ms
Controller Timer 54.75 ms
Controller Constructor Timer 38.81 ms
Query Database 0.26 ms
Event: dbquery Events 0.01 ms
Query Database 0.18 ms
Event: dbquery Events 0.01 ms
View: /themes/admin/layouts/layout.php Views 15.01 ms
After Filters Timer 0.94 msIn contrast I have another sytem using codeigniter 2, and its loading 130,000 records in less than a second. Using pagination from CI2. So there has to be something wrong about the new pagination?
RE: Pagination is slow? - InsiteFX - 04-28-2024
Turn off the Debug Toolbar and see if you still have a delay.
RE: Pagination is slow? - xsPurX - 04-29-2024
Thanks,
That actually worked!
