Find Jobs
Hire Freelancers

Reduce MySQL query execution time to 1ms

$30-250 AUD

Cerrado
Publicado hace más de 4 años

$30-250 AUD

Pagado a la entrega
Hi there, I'm looking for an expert MySQL DBA (or equivalent) to reduce the execution time of my MySQL query to 1ms or less. I have attached the database schema of the relevant tables, the PHP code which generates the query, current table sizes and row counts, and a sample query. I can supply full table data to freelancers I speak with who are interested in the project and think they can achieve my target. Please note these very important parameters when considering bidding: 1) Current execution of the sample query in my environment with no load is 60-200ms, so I am looking for over a hundred-fold improvement. I won't accept a query that runs "faster" - it needs to run for 1ms or less 2) I am on a shared host (GoDaddy reseller) running MySQL 5.6. Please don't suggest moving hosting providers, VPS, MySQL upgrades or anything that involves the Linux shell or super-user/root access. None of these are possible. Your job is to optimise my query in my current environment 3) Further to the above, no MyQSL configuration changes are possible. I'm happy to supply you with whatever configuration parameters you need prior to you bidding, but they can't be changed 4) Changing my query, adding indices, changing column data formats and similar are all acceptable 5) What is not acceptable is anything that would fundamentally change my app logic (splitting tables etc.) Please let me know if you have any questions, otherwise happy bidding!
ID del proyecto: 20891261

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 5 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
14 freelancers están ofertando un promedio de $151 AUD por este trabajo
Avatar del usuario
Hello Hope you are doing well. I have 7 years of experience in Linux and MySQL. I can reduce the MySQL query execution time. Regards VishnuLal*
$150 AUD en 1 día
4,9 (341 comentarios)
7,0
7,0
Avatar del usuario
Hello. I would like to help you with mysql query optimization. I have experience. Please read my feedbacks. Thanks.
$111 AUD en 1 día
4,9 (584 comentarios)
7,1
7,1
Avatar del usuario
Hello :) Thanks for your posting. I saw your description carefully. I am a web expert who have 8+ years of experiences. My skills are Html5,CSS,SCSS, Bootstrap,Javascript,Jquery,MySql,PHP especially MySQL is really my type ... I can implement your project with fully and completely. I can help you with my best. I hope that you contact with me. If you need, i will send my live link to you Thank you :)
$130 AUD en 2 días
4,9 (29 comentarios)
5,3
5,3
Avatar del usuario
Hello i have experience in mysql optimization and imho can help you, i'm open to discuss and ready to job.
$90 AUD en 2 días
5,0 (21 comentarios)
4,7
4,7
Avatar del usuario
Hi Sir please add the indexes on columns. Adds prepare keywords with remove joins. these all things i have use in Ali Express scraping data. Which brings results faster. Regards Ahmed Awan
$133 AUD en 2 días
5,0 (9 comentarios)
4,3
4,3
Avatar del usuario
i can work for jquery High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
$77 AUD en 7 días
3,4 (53 comentarios)
5,2
5,2
Avatar del usuario
Hii. I am expertise in aql queries i will fuldill ur need ping me if u are interested and also let me know total rows of the table
$166 AUD en 2 días
4,7 (8 comentarios)
3,7
3,7
Avatar del usuario
We've been working on different platforms, like CRM, Bootcamps and Customer Surveys, and all these platforms requires optimized / faster queries to handle concurrent users. We hope that we will be able to work with you and have a chance to scale and optimize your queries.
$300 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, looking at your project description, I think this is the best suited job for me as I have over 8 years of experience in Database Development along with Performance Tuning. I have worked on various Databases like Oracle, SQL server, PostgreSQL etc. I have done OCA certification in Database Development and Oracle 12c: Performance Tuning and Management certification. Expecting a call from you where we can discuss further and I can prove my knowledge for this job to you.
$140 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Sydney, Australia
5,0
53
Forma de pago verificada
Miembro desde mar 8, 2012

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.