Find Jobs
Hire Freelancers

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

₹1500-12500 INR

종료됨
게시됨 4년 이상 전

₹1500-12500 INR

제출할때 지불됩니다
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.
프로젝트 ID: 23882148

프로젝트 정보

4 제안서
원격근무 프로젝트
활동 중 4년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
4 이 프로젝트에 프리랜서들의 평균 입찰은 ₹9,528 INR입니다.
사용자 아바타
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 7일에
4.9 (273 건의 리뷰)
6.9
6.9
사용자 아바타
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 2일에
5.0 (1 건의 리뷰)
1.6
1.6
사용자 아바타
· 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 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (INDIA)
Navsari, India
4.8
8
결제 수단 확인
3월 15, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.