A more efficient pagination library? |
So the pagination library works great for working with smaller data sets. However I need to paginate a table of 500,000 records and the pagination is dogshit slow with some queries taking upwards of 30s to run.
I've been reading about it recently and am interested in implementing a more efficient pagination. Couple of articles here: https://www.xarg.org/2011/10/optimized-p...ing-mysql/ https://www.eversql.com/faster-paginatio...t-is-slow/ Has anyone already implemented a faster pagination library for CodeIgniter before I embark on doing similar myself?
I think it is not CI's pagination library that you have issue with, but the speed of your database query for pagination
Those optimizations are fine for an existing database, but every database is different
and needs different optimizations. There is no one way to optimize them. It's up to you to setup the right index keys and normalization of the database. What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
But even with an index pagination with that many records can be painfully slow. The alternative methods I mentioned all used the Id of the first/last items on the current page.
Anyway, by sounds of it there is no alternative pagination library already written so I will roll my own.
If your going to roll your own then I would make it an Ajax Pagination Library.
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
|
Welcome Guest, Not a member yet? Register Sign In |