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.

Kemahiran: MySQL, PHP, Kejuruteraan Perisian, SQL, Ubuntu

Lihat lagi: 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

Tentang Majikan:
( 50 ulasan ) Barnsley, United Kingdom

ID Projek: #17324072

49 pekerja bebas membida secara purata £157 untuk pekerjaan ini


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 Lagi

£277 GBP dalam 7 hari
(439 Ulasan)

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 Lagi

£133 GBP dalam 3 hari
(235 Ulasan)

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 Lagi

£350 GBP dalam 3 hari
(110 Ulasan)

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 Lagi

£150 GBP dalam 3 hari
(74 Ulasan)

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 dalam 3 hari
(200 Ulasan)
£150 GBP dalam sehari
(89 Ulasan)

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 Lagi

£180 GBP dalam 3 hari
(33 Ulasan)

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 Lagi

£200 GBP dalam 3 hari
(53 Ulasan)

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 Lagi

£150 GBP dalam 3 hari
(20 Ulasan)

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 Lagi

£125 GBP dalam 3 hari
(52 Ulasan)

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 dalam 3 hari
(86 Ulasan)

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 Lagi

£222 GBP dalam 10 hari
(33 Ulasan)
£150 GBP dalam 3 hari
(26 Ulasan)

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 Lagi

£150 GBP dalam 2 hari
(56 Ulasan)

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 Lagi

£100 GBP dalam 4 hari
(75 Ulasan)

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

£222 GBP dalam sehari
(35 Ulasan)

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 dalam 3 hari
(89 Ulasan)

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 Lagi

£100 GBP dalam 3 hari
(22 Ulasan)

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 dalam 3 hari
(43 Ulasan)

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

£130 GBP dalam 2 hari
(36 Ulasan)