Efficiently Loading Paginated Results From MySQL with Just One Query Per Page

There are many situations in which pagination of query results is very useful, especially for performance optimization. ┬áIn most of these kinds of situations, the paginating of results requires you to determine the total number of results, so the application knows the number of pages available. The most common way to do this, is to… Continue reading Efficiently Loading Paginated Results From MySQL with Just One Query Per Page