In order to do Pagination I could only think of two methods. First off I am using PHP as my server side scripting.
So Currently I run a MySQL Statement. To get a Total Count of records that fit the query.
Then I run the same exact Query but I add a Limit Statement to me. To me this seems excessive and not efficent so i though would it be better to just run the query once and then allow PHP to create limits.
Any thoughts on this? How are you doing Pagination?