Optimizing a MySQL query across multiple databases and tables

I have an existing MySQL query that takes about a couple mins to complete.

I need to optimize this query (with indexes or some other methods you should know) to return as fast as a another sample MySQL query that does the same, but using different means to query.

I will share both MySQL queries and share remote access to a test server with a cloned database of our production that you can test however you would like.

Taidot: Tietokannan hallinto, Linux, MySQL, SQL, Windows Server

Näytä lisää: mysql index optimization, mysql optimize all tables, mysql optimize table without locking, mysql query optimization, mysql analyze all tables, mysql database optimization techniques, mysql large table optimization, mysql table slow optimize, php mysql query multiple, create multiple databases mysql bash, complex sql query multiple tables, multiple temp tables query, mysql multiple databases magento, dnn query multiple databases, optimizing mysql query, optimizing mysql query scripts php, fast mysql query, mysql query parent child, 2013 lost connection mysql query, asp mysql query

Tietoa työnantajasta:
( 0 arvostelua ) Redondo Beach, United States

Projektin tunnus: #17121350

Myönnetty käyttäjälle:


Hi, I have good proficiency in sql. I would like to optimize your mysql query on the test server. Available to start now. Regards, Manish

$20 USD 0 päivässä
(58 Arvostelua)

32 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$30 USD 1 päivässä
(34 arvostelua)

Hi, I am willing to offer you my services for the position of MYSQL I have experience with SDLC for more than 1 year & i always try my best to execute projects according to SDLC principles. I do have technica Lisää

$30 USD 1 päivässä
(6 arvostelua)
$20 USD 1 päivässä
(63 arvostelua)

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting) including ER Dimensional Modelling. Below are some key are Lisää

$35 USD 1 päivässä
(39 arvostelua)

I am having more than 9 years of experience in IT industry.I have worked on .net(,,asp,,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Lisää

$40 USD 1 päivässä
(28 arvostelua)

Hello, I have good experience in MySQL query and can optimize it in best possible way, please let me know when to start.

$50 USD 1 päivässä
(29 arvostelua)

Hello, I have an expertise in SQL queries, optimization, Indexes, TSQL. I can certainly help you here to improve the performance of your query. Looking forward to connect with you and take a look at the query on Lisää

$35 USD 1 päivässä
(6 arvostelua)
$10 USD 1 päivässä
(19 arvostelua)
$30 USD 1 päivässä
(27 arvostelua)

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please feel free to discuss the project with me so that I can wrap Lisää

$30 USD 0 päivässä
(2 arvostelua)

Respected Employer, I will optimze your database queries. I will deliver you in decided time duration with 100% satisfaction. Quality and guarantee work should be provided to you. If you have any questions please l Lisää

$15 USD 1 päivässä
(5 arvostelua)

I am experienced in web development using PHP, CODEIGNITER, MYSQL, MYSQLI, POSTGRE, GIT, API, WEB SCRAPING, CAKE PHP, CUSTOM FRAMEWORKS ,YII2, Nodejs, Angularjs , Laravel and also added Paypal, [login to view URL], ccavenue, Lisää

$30 USD 1 päivässä
(8 arvostelua)

H i iam also having the same environment like you mssql and mysql so i could able to work this and please let me know more details

$30 USD 3 päivässä
(2 arvostelua)

Hi. I have a lot of experience with Oracle, MySQL and SQL Server, I can help you with your optimizing. Please share with me your queries and tables examples to check it.

$30 USD 10 päivässä
(2 arvostelua)

Hello. I'm expert at Mysql programming. If you hire me, I can do it in 1 hour. Please interview with me. Thanks.

$55 USD 1 päivässä
(2 arvostelua)
$25 USD 1 päivässä
(1 arvostelu)

This project will require strong SQL skills, and this is what I’ll bring to the table. I will make it worth your while…satisfaction guaranteed

$25 USD 1 päivässä
(0 arvostelua)
$20 USD 1 päivässä
(0 arvostelua)

I have been in Database world from last 20 years.I can help you with your project Thanks Kantheti

$55 USD 1 päivässä
(0 arvostelua)

Hi I am new to freelancing. But I have 6 years if experience in database development. We can make the query work as per your expectations. Thanks

$20 USD 1 päivässä
(0 arvostelua)