Find Jobs
Hire Freelancers

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

$10-30 USD

Terminado
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 7078350

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I'm a PHP developer and also I'm working with Mysql. Please contact me and let's discuss. Thanks.
$25 USD en 1 día
5,0 (13 comentarios)
2,8
2,8
13 freelancers están ofertando un promedio de $43 USD por este trabajo
Avatar del usuario
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 en 1 día
4,9 (475 comentarios)
7,8
7,8
Avatar del usuario
A proposal has not yet been provided
$30 USD en 1 día
5,0 (58 comentarios)
5,4
5,4
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
5,0 (33 comentarios)
5,1
5,1
Avatar del usuario
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 en 1 día
5,0 (40 comentarios)
4,9
4,9
Avatar del usuario
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 en 1 día
4,9 (22 comentarios)
4,6
4,6
Avatar del usuario
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 en 1 día
5,0 (8 comentarios)
2,3
2,3
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$55 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Bromsgrove, United Kingdom
5,0
49
Forma de pago verificada
Miembro desde may 21, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.