I am using server side Data-table using codeigniter with pagination of 10-20 records. It works perfectly if the data is just from single table but in my case i am using multiple joins in table and then generating the results, and here it takes more than 5 minutes (On local machine and live server both). I have tried with VIEW and StoredProcedure both but nothing seems quite fast. Also here to note that the data is year wise.
I.E. there is a column in tables of savedYear and based on year i am retrieving the data.
There are 10,00,000 data in Year 2018
There are 50,00,000 data in Year 2019
There are 90,00,000 data in Year 2020
And i am trying to get the data year wise. In stored procedure i have passed the parameter of year to query and based on that running the query.
I am open for all options like caching, other plugins etc. My only concern is to load the data very fast.
NOTE: Any suggestion/solution will be tested first and then payment will be done. NO RESULT NO PAYMENT.
4 freelancer đang chào giá trung bình ₹9528 cho công việc này
thanks for your post, i read your problem and it is easy for me because i always use it with codeigniter framework. if there is any request for your datatables I will do that too.