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

₹600-1500 INR

Closed

Posted

about 4 years ago

₹600-1500 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.

PHP

Codeigniter

Software Architecture

Microsoft SQL Server

SSIS (SQL Server Integration Services)

Project ID: 23881867

About the project

2 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

2 freelancers are bidding on average ₹1,275 INR for this job

@akabdul003

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 believe in quality work with on-time delivery. Kindly initiate a chat to discuss more. Regards

₹1,000 INR in 7 days

5.0

(1 review)

1.1

@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

₹1,550 INR in 2 days