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.

Evner: MySQL, PHP, Software Arkitektur, SQL, Ubuntu

Se mere: 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

Om arbejdsgiveren:
( 50 bedømmelser ) Barnsley, United Kingdom

Projekt ID: #17324072

49 freelancere byder i gennemsnit £157 på dette job


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 Flere

£277 GBP in 7 dage
(439 bedømmelser)

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 Flere

£133 GBP in 3 dage
(235 bedømmelser)

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 Flere

£350 GBP in 3 dage
(110 bedømmelser)

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 Flere

£150 GBP in 3 dage
(74 bedømmelser)

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

£100 GBP in 3 dage
(200 bedømmelser)
£150 GBP på 1 dag
(89 bedømmelser)

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 Flere

£180 GBP in 3 dage
(33 bedømmelser)

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 Flere

£200 GBP in 3 dage
(53 bedømmelser)

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 Flere

£150 GBP in 3 dage
(20 bedømmelser)

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 Flere

£125 GBP in 3 dage
(52 bedømmelser)

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.

£150 GBP in 3 dage
(86 bedømmelser)

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 Flere

£222 GBP in 10 dage
(33 bedømmelser)
£150 GBP in 3 dage
(26 bedømmelser)

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 Flere

£150 GBP in 2 dage
(56 bedømmelser)

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 Flere

£100 GBP in 4 dage
(75 bedømmelser)

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, Flere

£222 GBP på 1 dag
(35 bedømmelser)

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

£100 GBP in 3 dage
(89 bedømmelser)

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 Flere

£100 GBP in 3 dage
(22 bedømmelser)

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.

£150 GBP in 3 dage
(43 bedømmelser)

I can automate this work by php, please send me details...............................................................

£130 GBP in 2 dage
(36 bedømmelser)