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



Mysql Optimization For VPS

Updated June 16, 2015 13:00 PM

Optimizing mysql and apache ovh vps

Updated August 27, 2015 18:00 PM

Is it safe and senseful to keep MySQL threads alive

Updated November 03, 2015 13:00 PM

How can I lower MySQL single-page reads?

Updated May 17, 2015 05:00 AM