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

₹1500-12500 INR

Closed

Posted

over 4 years ago

₹1500-12500 INR

Paid on delivery

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. Ex. 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.

Codeigniter

Microsoft SQL Server

PHP

Software Architecture

SSIS (SQL Server Integration Services)

Project ID: 23882148

About the project

4 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹9,528 INR for this job

@Max01

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 with my experience in the development activities. Might be due to client side paging effects ******Please send me a message so that we can discuss more.****** Gladly waiting to serve you with my extensive skills. Thank you for reading my proposal.

₹10,000 INR in 7 days

4.9

(273 reviews)

6.9

@rushabhdesai

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. My first priority is to make client 100% satisfied with my work and efforts. I promises to be unbeatable solution for all your business needs, providing high quality! I have developed many complex projects such as Education Portals, Community Portals, Real Estate Portals, Job Portals, Daily Deals & Coupons websites, B2B, B2C Portals, Classified Portal, Social Networking website, Affiliate based websites, Price comparison websites. I am proficient with PHP framework like - PHP - Codeigniter - Laravel - Cakephp - MYSQL - API development / Third Party API integration like Facebook, google, SMS integration, Payment Gateway Integration - JQuery - Angular Welcoming you to discuss your project and want to give best solution.

₹7,000 INR in 2 days

5.0

(1 review)

1.6

@navinmalik7

· 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 status, addressing user requirements, Database Mail, Database Configuration, Query Tuning and performance. · Having knowledge to managed and administered database. Initiated a project to consolidate servers and to remove old/unused databases. · Having experience to install and configured SQL 2016 clustered environment with availability groups. · Having experience to install and configured a SQL 2016 clustered test environment. · Configured and supported replication and log shipping in both SQL 2014 and 2016. · Documented processes for installations, clustering, availability group setup, and patching. · Designed Contract Retention database using SQL Server 2016 technology · Developed data mapping documentation to establish relationships between source and target tables including transformation processes · Created complex SQL views and stored procedures to join multiple tables for contract data interface files. · Having experience in optimize the SQL Query and SSIS packages (2016), migrate SSIS version from lower to latest version. · Having experience to diagnosed job errors like deadlock and timeout issue. · Experience in SSIS for bulk uploading data into Database, File

₹11,111 INR in 5 days

0.0

(0 reviews)

0.0

@merzon15

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.

₹10,000 INR in 7 days