Fast Load large data using data table and codeigniter (Morethen 10,00,000 Rows)

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.

Beceriler: PHP, Codeigniter, Yazılım Mimarisi, Microsoft SQL Server, SSIS (SQL Server Integration Services)

Daha fazlasını gör: load xml using asp, using soap codeigniter, load array sql table 2008, mysql millions of rows performance, speed up mysql queries large tables, mysql insert 1 million rows, improve mysql performance large database, how to fetch data faster from mysql, jquery datatables load large data client side, fetch large data mysql php, query optimization in mysql with example, load large csv files mysql, load large database mysql php, joomla fast load, mysql load large file, php load large file, load large volume data oracle mysql, fast fourier transformfft using, mysql load large data files, load flow using psaf

İşveren Hakkında:
( 8 değerlendirme ) Navsari, India

Proje NO: #23881867

Bu iş için 2 freelancer ortalamada ₹1275 teklif veriyor


Hello Sir, I am glad to place a bid on this job. I have read your description and I'm filled with confidence to do your work. I've done something similar to it. If you will trust me I will do my best for you. I belie Daha Fazla

₹1000 INR in 7 gün içinde
(1 Yorum)

· Provided strategic direction for the database team and functioned as the tech lead on projects. · Having experience to perform day to day DBA activities such as monitoring SQL Server health, job stat Daha Fazla

₹1550 INR in 2 gün içinde
(0 Değerlendirme)