PHP Classes

Pagination

Recommend this page to a friend!

      Top level forums  >  PHP Specialists  >  General  >  Pagination  
Subject:Pagination
Summary:Storing a mySql query for pagination
Messages:3
Author:Nino V
Date:2011-11-21 11:32:02
Update:2011-12-15 02:14:09
 

  1. Pagination   Reply   Report abuse  
Picture of Nino V Nino V - 2011-11-21 17:48:52
Hi,

I have a big table to show allowing the user to sort the data on every column.

The problem is that every time the pagination code has to execute the query which takes very long. Is there a method to avoid that? I mean, is it possible to execute the query only the first time and putting the result in array, for example, to paginate (and sort) the array?

I hope the explaination is enough clear!

Thanks a lot,
Nino

There are 2 replies in this thread, which are not being displayed.
Browsing this forum thread replies is available only to premium subscribers.

Go to the premium subscriptions page to learn how to become a premium subscriber and have full access to this forum.