how optimizing mysql queries to retrieve data with pagination

by Muhammad   Last Updated October 11, 2018 15:00 PM

I have database with 12000 records and this records will increase by 600 records every day . I think that 12000 records not much data into database but when I trying to retrieve data by php , it took many time to retrieve it and sort it in pagination , I using index with my database , but I think pagination take more time and cause the late , I am using ADMINLTE Template and this template make pagination for all records at same time this is the url of template ADMILTE TEMPLATE

I think if I make pagination to be done page by page will be more quick but I don't know how to do that ,I wish I explained my problem clearly , and sorry about my so bad English language

Related Questions

Updated October 02, 2015 12:00 PM

Updated June 16, 2015 13:00 PM

Updated August 27, 2015 18:00 PM

Updated November 03, 2015 13:00 PM

Updated February 27, 2019 22:00 PM