Find Jobs
Hire Freelancers

Debug slow PHP script

€30-250 EUR

Closed
Posted over 8 years ago

€30-250 EUR

Paid on delivery
Hello, I have a PHP script which imports products into 4 tables. - Main productinfo - Productimages - Product barcodes/EAN - Productimages The script downloads XML files from ICECAT in order to get the product information. This all works. Problem is, is that whenever I do more than 70 products in 1 script run, it slow down terribly. 70 products between 6-8 seconds. 75 products 10 minutes. This project is about debugging the script and find out the reason why it's slowing down. As far as I know it's not a RAM or CPU shortage. Experience is the key in this project.
Project ID: 8297861

About the project

39 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average €132 EUR for this job
User Avatar
Hi I am much experienced in PHP.I can do this please discuss the project. ready to start asap. waiting for your reply. Thanks
€147 EUR in 2 days
4.8 (525 reviews)
9.3
9.3
User Avatar
I can debug it for you. its just some kind of looping which causes this problem. are you able to provide me access to your script to take a look and confirm later?
€147 EUR in 3 days
4.9 (1050 reviews)
9.1
9.1
User Avatar
Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
€210 EUR in 1 day
4.9 (1053 reviews)
8.9
8.9
User Avatar
Hi sir, Maybe I can help you for this, can you send me the script and I can check more? Thanks, Kimi
€155 EUR in 3 days
5.0 (385 reviews)
8.0
8.0
User Avatar
Dear Sir, Hope you are doing well today. I have read your project description, i am willing to debug this script as per your requirements. i have done this similar work before and got a 5 star rating. Looking forward for your response. Kind Regards, Rashid
€63 EUR in 3 days
4.9 (69 reviews)
8.0
8.0
User Avatar
Hi Sir/Madam. Ready to start. Thanks. *** I will pay 15% penalty if the project is not completed on time ***
€188 EUR in 3 days
4.9 (468 reviews)
7.4
7.4
User Avatar
Hi Employer, I have read your description and been interested in your project. Please give me your script, sample database and XML so that I may run the test? I'm ready to discuss and start to work on it now. ==================================== Please discuss before awarding the project.
€105 EUR in 3 days
4.7 (132 reviews)
7.6
7.6
User Avatar
Hello. I have very big experience for icecat, have developed icecat import modules for Magento, ZenCart, oscommerce. Probably your script is doing insert row by row into every table. To make tables loading really fast it should prepare text files first and then use LOAD DATA LOCAL INFILE mysql instruction. Please let me know if you are interested, I believe I can help you. Thanks, Vitaliy.
€111 EUR in 3 days
4.9 (115 reviews)
7.1
7.1
User Avatar
Hi, I am an expert PHP and MySQL developer. I am interested in your project and I would like to go into details with you. I understand very well the problem. I would need to check the source in order to determine the source. Hopefully the problem is not on the request to ICECAT (XML files) Thanks in advance and best regards, Fabian von Romberg
€150 EUR in 3 days
5.0 (56 reviews)
6.4
6.4
User Avatar
Propunerea nu a fost încă furnizată
€111 EUR in 4 days
5.0 (38 reviews)
6.1
6.1
User Avatar
Hello I understand your requirement, i will fix the issue you are facing in your website. The issue is 70 products between 6-8 seconds. 75 products 10 minutes. Regards Anaya
€155 EUR in 3 days
4.8 (76 reviews)
6.5
6.5
User Avatar
Dear Sir we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by replying.. hope to hear you soon.. -- Thanks & Regards PROMITI
€128 EUR in 3 days
4.8 (81 reviews)
6.3
6.3
User Avatar
Hi there, If you don't mind, can you please show me the script in a test file? I will see it and try to fix it right away as I am currently free and have no work to do. Let me know if agreed with quote and time frame. Best Regards, Kashif.
€75 EUR in 1 day
5.0 (41 reviews)
6.2
6.2
User Avatar
Hello, I can take a look at it, even the 6-8 seconds for 70 products sounds too long and very strange it goes up by 10 minutes for just 5 products more. I used to run my own site importing data and doing arround 100.000 inserts/updates/deletion and anaylzing the data and that took in average 1.5s per run. Got over 15 years experience and performance tuning is one of my beloved areas. Sincerly, Thorsten Sanders
€60 EUR in 1 day
5.0 (22 reviews)
5.6
5.6
User Avatar
I have a computer engineering degree from CMU and I've been programming for 20 years. I've done a lot of performance tuning and fixed a lot of critical problems. I've been programming with PHP for the last 5 years. I can solve your performance problem, although keep in mind it might not be the PHP. It might be DB interaction or waiting on socket input, etc. But I will track it down and fix it.
€150 EUR in 3 days
5.0 (49 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
€88 EUR in 1 day
5.0 (96 reviews)
5.8
5.8
User Avatar
Hello. I will need more details like what are You using to parse XML. From my experience You are using ineffective parser or Your script is not handling memory too well. First try to increase memory limit and wait for results, check if You can lower memory usage in this script, if it's not better change XML parser to a different one
€84 EUR in 3 days
5.0 (8 reviews)
5.2
5.2
User Avatar
Hello. I have experience with xml processing. Could you provide XML file, PHP script, DB structure dump?
€55 EUR in 1 day
5.0 (15 reviews)
5.3
5.3
User Avatar
Hello Sir , I am 100% Sure That i am Perfect For This Job. I have 5 Year Of Exp. In Same Feild And I am Available For 24*7 Support . ALso We Offer You a 30 Days Free Maintainance. Please Message Me Once before You Award The Project . I'll Give You best Deal Possible. Regards Webexe Solutions
€147 EUR in 3 days
5.0 (29 reviews)
4.6
4.6
User Avatar
Hey, Hope you remember me from the "PHP Encoding issue" project I've helped you with. I want to get a take at this project, this seems fun and I think I can help you. I already have an idea what's the problem and an idea how to fix it quickly! Price is negotiable by the way ;)
€222 EUR in 2 days
5.0 (18 reviews)
3.7
3.7

About the client

Flag of NETHERLANDS
's-Gravenzande, Netherlands
5.0
50
Payment method verified
Member since May 10, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.