Đã Đóng

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

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.

Kĩ năng: Codeigniter, Microsoft SQL Server, PHP, Kiến trúc phần mềm, SSIS (SQL Server Integration Services)

Xem nhiều hơn: 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, how to speed up mysql queries in php, 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

Về Bên Thuê:
( 8 nhận xét ) Navsari, India

ID dự án: #23882148

4 freelancer đang chào giá trung bình ₹9528 cho công việc này


Thank you for your posted project and hope you are doing great. I am Neeraj and very happy to have a chance of bidding your project. I've read your project description carefully and would love to work on this project w Thêm

₹10000 INR trong 7 ngày
(273 Nhận xét)

I have an experience of 11 years into web development using codeigniter, laravel, angularjs, MySQL, JQuery etc.. Looking for Professions? You are in the right place, TRY me!. I am sure, provide you the best solution Thêm

₹7000 INR trong 2 ngày
(1 Nhận xét)

· 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 Thêm

₹11111 INR trong 5 ngày
(0 Nhận xét)

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.

₹10000 INR trong 7 ngày
(0 Nhận xét)