Find Jobs
Hire Freelancers

Alter php/mysql script to use another table to track progress.

$10-30 USD

Completed
Posted about 9 years ago

$10-30 USD

Paid on delivery
We have a working php script that runs through a table in mysql, decoding HTML entities. The script however requires us to alter the table to add a new column to keep track of how far it has got, we have run into an issue where we have a table with 100million records in that the alter table command takes hours and hours to run. Instead we would like someone to alter the script to not require this alter table, or instead use another table we could create instead.
Project ID: 7078350

About the project

13 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hi, I'm a PHP developer and also I'm working with Mysql. Please contact me and let's discuss. Thanks.
$25 USD in 1 day
5.0 (13 reviews)
2.8
2.8
13 freelancers are bidding on average $43 USD for this job
User Avatar
Hey You can remember that we worked on this project. https://www.freelancer.com/projects/PHP-HTML.1/Fix-bug-php-script.html We can work again. Looking forward to hear from you. Thanks Rinsad
$34 USD in 1 day
4.9 (475 reviews)
7.8
7.8
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (58 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
5.0 (33 reviews)
5.1
5.1
User Avatar
Hi! I specialize in debugging and modifying third-party scripts. I can fix the tracking method of your HTML parsing script in an hour, if the change required is really as simple as just changing the table where tracking info is stored.
$25 USD in 1 day
5.0 (40 reviews)
4.9
4.9
User Avatar
We completed a difficult problem before, and I think this would be a lot easier. I've been doing sql for 14 years and bash for 20. I've written some complex SQL and bash here and have good reviews. I could get something done pretty fast.
$27 USD in 1 day
4.9 (22 reviews)
4.6
4.6
User Avatar
Hello. I saw your description. I can do it. But before start working for you,I want to discuss with you. Please contact me. Bye.
$24 USD in 1 day
5.0 (8 reviews)
2.3
2.3
User Avatar
Hello Sir, We are an Indian Web Development company having 4+ years experience. Our services include Website Design and Development, website speed optimization and server optimization, SEO. We have a huge experience and have done many projects in different platforms along with skilled team mates please send me the details etc. so we will talk more for your work. Waiting for your +ve response. Thanks and regarding, DLB INFOTECH
$20 USD in 2 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi, my name is Victor and I'm interested in your project. Do you use any CMS or frameworks or your project built on top of plain PHP? Feel free to contact me and together we will solve your issues. Thanks. Best regards, Victor
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
To whom it may concern, I look forward to solving your script issue. I specialize in database design, please review my profile. Added to this I have experience with php and MySQL. The issue with running alter table statements is not only the re-creation of the table but also the invalidating of the indexes used to query data out of the table. You need to re-look at the design of the solution because as you are experiencing performance will die as the solution gets bigger. I will not only fix your script but propose a design change to make the solution scalable. Regards, Justin
$27 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. From your description, it seems to me that it would be best to introduce a new table to support this process. This new table would keep track of the progress, tying it back to the existing table. Once my bid is accepted, I will analyze the current process and walk through a detailed approach to solve your issue. Thanks!
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bromsgrove, United Kingdom
5.0
49
Payment method verified
Member since May 21, 2010

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.