Đã Đóng

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.

Kĩ năng: MySQL, PHP, Kiến trúc phần mềm, SQL, Ubuntu

Xem nhiều hơn: 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

Về Bên Thuê:
( 50 nhận xét ) Barnsley, United Kingdom

ID dự án: #17324072

49 freelancer đang chào giá trung bình £157 cho công việc này

kchg

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 Thêm

£277 GBP trong 7 ngày
(439 Nhận xét)
9.6
octopus823

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 Thêm

£133 GBP trong 3 ngày
(235 Nhận xét)
9.0
A2Design

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 Thêm

£350 GBP trong 3 ngày
(110 Nhận xét)
8.6
extreamcode

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 Thêm

£150 GBP trong 3 ngày
(74 Nhận xét)
7.5
raisdhaka

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 trong 3 ngày
(200 Nhận xét)
6.8
£150 GBP trong 1 ngày
(89 Nhận xét)
6.5
JinNg

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 Thêm

£180 GBP trong 3 ngày
(33 Nhận xét)
6.5
schoudhary1553

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 Thêm

£200 GBP trong 3 ngày
(53 Nhận xét)
6.2
JiffystacksTech

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 Thêm

£150 GBP trong 3 ngày
(20 Nhận xét)
6.1
rashishm

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 Thêm

£125 GBP trong 3 ngày
(52 Nhận xét)
6.1
royalwebraisers

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 trong 3 ngày
(86 Nhận xét)
6.1
evaxsoftvw

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 Thêm

£222 GBP trong 10 ngày
(33 Nhận xét)
6.2
£150 GBP trong 3 ngày
(26 Nhận xét)
6.2
janudvs

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 Thêm

£150 GBP trong 2 ngày
(56 Nhận xét)
5.9
amin6106

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 Thêm

£100 GBP trong 4 ngày
(75 Nhận xét)
6.1
joomsavvy

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, Thêm

£222 GBP trong 1 ngày
(35 Nhận xét)
5.7
softcarve

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 trong 3 ngày
(89 Nhận xét)
5.9
techwobit

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 Thêm

£100 GBP trong 3 ngày
(22 Nhận xét)
5.8
yuansun235

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 trong 3 ngày
(43 Nhận xét)
5.8
nvbishr

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

£130 GBP trong 2 ngày
(36 Nhận xét)
5.4