PHP and MySQL Optimisation for existing scripts

I have a server based on a LAMP stack hosted on Digital Ocean, with some scripts that download large zipped csv files (one at a time), it then unzips the file and extracts the data in the file into my database tables.

One of the files it downloads is very large (millions of rows, usually) and is causing a few problems with my scripts. i need a PHP and SQL expert to go in an optimise it.

The errors I get are 500 errors and sometimes 524 I think.

Aptitudini: MySQL, PHP, Arhitectură software, SQL, Ubuntu

Vezi mai multe: php mysql best practices, how to speed up mysql queries in php, mysql select database php, php mysql example, how to optimize mysql query in php, mysql database optimization best practices, how to optimize select query in mysql, what is mysql query optimization, i have an existing php/mysql script that i need customized with additional functions, php mysql display existing table, php mysql cms existing website, php mysql table existing, php mysql upload video scripts, php mysql download exam scripts, sql server 2008 express import csv file, free php mysql real estate scripts, php mysql record management scripts, delivering zipped csv file php script, php mysql drop menu scripts, simple php mysql edit existing text

Despre angajator:
( 50 recenzii ) Barnsley, United Kingdom

ID Proiect: #17324072

51 freelanceri licitează în medie 161£ pentru acest proiect


Hi there. I am senior web developer who a lot of experience . My experience in web development is around 11 years and i have many experience of building and maintaining responsive web-application with bootstrap and Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 7 zile
(437 recenzii)

Dear Employer. I am very interested in your task. I read your proposal carefully. I am a talented and experienced PHP expert. I have much experiences in this aspect. I can complete your task perfectly. I want to Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(204 recenzii)

Hello! We are a team of 30+ web developers based in Russia. Our team is interested in developing your project. Having the required skills, we will be glad to help you. We have some questions regarding your projec Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(109 recenzii)

HI There, I can assist you with PHP and MySQL Optimisation for existing scripts. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. Y Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(71 recenzii)

Hello, I know Linux well to fix this issue. Large file import to DB need to do via SSH command, not phpmyadmin. Let's discuss. Regards Rais U

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(184 recenzii)
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(81 recenzii)

Hi, My name is Jin. Let's talk about your project. 1. You have a server error 500 & 524 during an import operation from a CSV to a MySQL DB. This normally indicates a PHP timeout error. 2. I faced a similar si Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(32 recenzii)

Hello, Greetings! We have reviewed your request for optimizing PHP and MySQL. Would you please revert back us at freelancer message box for a brief discussion regarding same? So, we can have a better idea of yo Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(19 recenzii)

Hi, i have lot of experience in parsing large files, one time i even parse 7GB zipped xml file and put rows to MySQL database. So i should be able to deal with issues you have. I personally have lot experience in deve Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 10 zile
(32 recenzii)

Hi, Extremely Expert in MySQL, PHP, Software Architecture, SQL, Ubuntu etc! I have gone through the entire work description very carefully and very confident that I will do this work for you within the reasonabl Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(48 recenzii)
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(26 recenzii)

Hi, Here is php and mysql expert. Do you want to debug and optimize existing code right? Can you please give me some information regarding database? Can you please give me some information regarding php and cod Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 2 zile
(56 recenzii)

Dear Hiring Manager, We can help you in optimizing the script. Let me know when we can discuss in more details and start working on it asap. Looking forward for your response. Thanks.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(64 recenzii)

Hello, I'm an Austin, Texas based developer with 12 years of LAMP stack programming. Sounds like a pretty straight forward optimization problem. I'd be happy to have a look and get it working properly. Regards, Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(35 recenzii)

Hi there..... Warm Greetings We came along with your request for PHP and MySQL Optimisation for existing scripts and we reviewed your project description. We'd like to help you with confidence and satisfying resu Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(44 recenzii)
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(19 recenzii)

Hi there, Hope you are doing well. Is this process automatic or being executed manually ? Do you have mysql and php on one node or on different node ? Do you have phpmyadmin installed ? One more thing yo Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 4 zile
(73 recenzii)

Hi, I would like to solve the issue for 500 Error. Get in touch to discuss more. Available to start now. Regards, Manish

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(84 recenzii)

Hello, I am proficient in mysql, sql statement, php. I'd like to have a discussion to get more details. What is the version of mysql on ubuntu? and php version? ubuntu version? Thanks, Best Regards.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(35 recenzii)

Hello, I always provide fastest results with quality. I have an experience of more than 10 years in web development and maintenance. I have in-depth knowledge of php, mysql, javascript , jquery, payment system integrat Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(16 recenzii)