Closed

Optimize a MySQL query

I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing and I can give the full tables and parameters to reproduce the query. I need to reduce the run time significantly! Thanks for your help.

Kemahiran: Pengaturcaraan Pangkalan Data, MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: optimize mysql phpbb3, edit csv mysql query, asp mysql query, optimize mysql query online, mysql query optimization and performance tuning, mysql query optimization techniques, mysql query optimization tips and tricks, mysql query optimization tool, mysql optimization, mysql query optimization tips, mysql explain query, php, mysql, database administration, database development, database programming, system admin, 2013 lost connection mysql query, optimize mysql query software, mysql load large data files

Tentang Majikan:
( 22 ulasan ) Half Moon Bay, United States

ID Projek: #17424292

45 pekerja bebas membida secara purata $178 untuk pekerjaan ini

octopus823

Dear Employer. I am very interested in your task. I read your proposal carefully. I am a talented and experienced MySQL expert. I can complete your task perfectly. I want to know your task in detail. Please cont Lagi

$155 USD dalam 3 hari
(206 Ulasan)
8.8
TenStar718

Hello, and thanks for the opportunity to bid on your project "Optimize a MySQL query" Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in man Lagi

$235 USD dalam 3 hari
(227 Ulasan)
8.6
$250 USD dalam 3 hari
(201 Ulasan)
8.2
shivmirthyusl

HI There, Thank you for the opportunity You are looking to find out where the bottlenecks are on your existing MySQL query and revise to complete faster. With the largest data set, the current runtime for a limit Lagi

$235 USD dalam 3 hari
(237 Ulasan)
8.3
dinhbang19

Dear Sir/Madam, I review the mysqlQueryHangs.php. It is using Union and create temporary table when execute the select command. It means It has to create tmp_unions then insert before selected. We need use Join or c Lagi

$200 USD dalam 3 hari
(149 Ulasan)
7.6
dlbinfotech

Yes, sure !! I can optimize your website and also i can improve performance as well according to the Gtmetrix and Google page insight. Kindly provide me following : - ADMIN - FTP/Cpanel - SSH ROOT access I Lagi

$300 USD dalam 3 hari
(76 Ulasan)
7.3
vw580939vw

Dear Sir, Greetings! As we have 16+ years of working experience, looks doable. Though, we can give the best TRY to get this sorted. We need database/code access, which is required. We need approx. 8 hours at U Lagi

$88 USD dalam 5 hari
(158 Ulasan)
7.4
liangjongai

I'm interested in your project very well. I've got an experience in jobs with skills like yours. Please ping me to discuss about this project.

$164 USD dalam 3 hari
(274 Ulasan)
7.5
hardikmemagara

Hello, I will complete your every requirement as per your need that you have mentioned in your job details. We are group of PHP experts. Will support after the work done as well. so please Come to the discussion ab Lagi

$200 USD dalam 2 hari
(314 Ulasan)
7.1
spiretech

Hello Greeting Of the day!! I can help you for sure to Optimize a MySQL query Let’s discuss a little My web and mobile portfolio [login to view URL] Best design www Lagi

$200 USD dalam 6 hari
(87 Ulasan)
6.9
SoftSandila

hi i can optimize these MySQL query for you and reduce the results time significantly, regards, adnan

$155 USD dalam 3 hari
(65 Ulasan)
6.5
$235 USD dalam 2 hari
(58 Ulasan)
6.6
ARKSolution2015

Sir, I have gone through your project description and am looking to provide my service for the query optimization. For more than 7 years I’ve worked in this field.

$105 USD dalam 3 hari
(138 Ulasan)
6.5
sveralex

Hello. Please send a full script(s) and MySQL database dump or provide access to your database. --- Thank you. Alexey

$100 USD dalam 2 hari
(137 Ulasan)
6.1
deep0209

you should change MyISAM to Innodb engine. rest I can go through query to improve its efficiency. I have expertise in PHP, HTML, Wordpress, CSS, MySQL, JS. With 5+ years of experience in web development, I believe Lagi

$288 USD dalam 3 hari
(62 Ulasan)
6.2
schoudhary1553

Hi there, Warm Greetings We came along with your request for Optimize a MySQL query and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals Lagi

$250 USD dalam 3 hari
(42 Ulasan)
5.9
pabloramirezdz

Hello! My name is Pablo, I'm a developer and sysadmin with 12+ years experience. I have good knowledge of db and server administration (MySql/Linux and windows). To be honest, it's very difficult to see what's wr Lagi

$235 USD dalam 3 hari
(35 Ulasan)
5.8
luiswilliam

Hello, I am Mysql query expert and mysql statement programming also. Please ping me to discuss more detail.

$155 USD dalam sehari
(55 Ulasan)
6.0
yangdev

Hi As a professional web developer, I can help you to reduce run time. Over 10+ years, I 've worked as backend developer and db manager. I've mastered query and love to make optimized queries. I can help you righ Lagi

$133 USD dalam sehari
(25 Ulasan)
5.5
mahmoudgamal008

I will rewrite the query again and optimize it as I can. Then, I will check the tables structures and the tables' indexes. I will create any necessary indexes to speed up the query. --------------- ABOUT ME -------- Lagi

$200 USD dalam 3 hari
(41 Ulasan)
5.5