MySQL Query Performing Slowly! Fix MySQL Query Issue.

$30-250 USD

Zavřený

Zveřejněno

před více než 5 roky

$30-250 USD

Zaplaceno při doručení

My website has a big database of advertisements where there are approximately 500,000 ads. My website's SQL query is not being able to handle this huge database and few SQL queries are being executed very slowly. The website is hosted in a very good dedicated VPS, so hosting server is fine for the huge database but the website's SQL query need to be modified so that it can load and perform faster. My VPS >> "MySQL Slow Query" log showing few specific queries are taking too long and those queries are affecting other queries to be executed slowly!! I need you to fix this SQL query issue. my guess is, current SQL queries are not using proper "INDEX" & "SELECT" queries without limit! There are 3-6 queries i think (can be bit more, not sure!) which are loading slowly and making other queries load slowly and you will be fixing those in this project. After completing this project, i will need you to work on another few projects for me, so your bid should be with a reasonable price because of ongoing job! If you can't work on this project right away, please do not bid ! ! !

IČ projektu: 17614791

O projektu

40 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

40 freelanceři nabízejí v průměru $148 USD za tuto práci

@mekiho

Dear employer. I have read your project description carefully. Before, I have worked with 3 million records to speed up and I have reduce loading time as 2 sec. I'm very confident working with mysql programming so that I can provide you perfect result. Please contact me and let us discuss. Thank you.

$200 USD v 3 dnech

5,0

(92 recenze)

7,7

@bjrupani

Hello hiring member i hope you are doing well i am bhavika i have 2.5+years experience in php ,laravel ,ajax,jquery ,javascript also i can do any mysql stuff and i can start your project right now and i have really good team who have great experience in php ,mysql so you can trust in my and my teams skill so please give us chance to serve you thanks in advance :)

$166 USD v 3 dnech

5,0

(219 recenze)

7,8

@royalwebraisers

Dear Hiring Manager, We can help you in the project to make fast slow queries.. I am good in: php, codeigniter, laravel, jquery, google map api, MySQL. Let me know when we can discuss in more details and start working on it asap. Looking forward for your response. Thanks

$77 USD v 3 dnech

5,0

(163 recenze)

6,8

@usama13

Hey, Inbox me to start working on this project right now. I will check all queries and will update the queries so that it will work fast. I wont ask for payment until your 100% satisfaction. Thank you waiting for your response.

$100 USD v 0 dni

5,0

(61 recenze)

6,5

@vishal817

I understand the Issue, I will Index the database or will make the Query which will load faster. Lets discuss. Thank you Vishal

$200 USD v 1 dni

5,0

(28 recenze)

6,7

@arjun366333

Ready to start the work to Fix MySQL Query Issue, We can discuss more over chat, Thanks Regard Arjun S.

$110 USD v 3 dnech

4,4

(28 recenze)

6,0

@vinaysinghh

I am MySQL DBA having more than 8 yrs of experience and I have completed many projects for MySQL query optimisation

$111 USD v 1 dni

4,8

(59 recenze)

5,5

@delostyle

Hi , I have gone through the job details carefully and I am excited to start working on this project. I am confident that I can exceed your expectations by my quality of delivery. I have an extensive knowledge of Php, Wordpress, MySql, Html5, Css3, Javascript and more. I will be able to contribute to this project by: fixing Mysql query issue as per your requirement . which will complete the project in time and with all required functionalities. Please let me know of a good time so that we can discuss about the fine points of the projects. Looking forward to build up a long term professional relationship with you. Thanks Rajib

$100 USD v 2 dnech

5,0

(18 recenze)

4,8

@JohnMary

Greetings, I have gone through the job description and i am very much comfortable to work on this project. I am available to discuss the project and ready to get started. Please share further details so I can start working on it. I have 10 years of experience in web development and i am expert in my domain areas like php advance frameworks, ROR, Laravel, Codeigniter, and hands on in all CMS like wordpress, drupal, Magento, shopify, weebly, php motion, joomla, opencart , woocommerce, big commerce etc. I have extensive knowledge of Photoshop, Designing, html5, css3, javascript, ajax, angular.js, Mysql, jquery, bootstrap, and payment integration modules. I assure you that you will experience a WOW factor in our work. Many Thanks Umair Majeed

$250 USD v 4 dnech

5,0

(16 recenze)

4,6

@deytps86

Hello I extensively worked in MySQL/Oracle and DB2 query optimization and performance tuning. Can we discuss more in details? Thank you!

$220 USD v 3 dnech

5,0

(13 recenze)

4,5

@drahul540

Hello, I am expert in mysql and i have done many project like query management for speed up process. I was also worked with huge database. If you are interested so chat with me so we can start your project as soon as possible. Thank you

$120 USD v 3 dnech

5,0

(7 recenze)

3,7

@nojnish

Hi, I have 15+ years in sql development and query optimization in variety of databases such as MSSQL, MySQL and 5+ years specifically in MySQL database. hope to hear from you regards Babu

$200 USD v 3 dnech

5,0

(2 recenze)

3,6

@hashanchamikara

I can help you price can be negotiable after the task explain -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

$150 USD v 1 dni

5,0

(6 recenze)

3,1

@pukivaidhya

Hey !! Greetings for the Project !! We are expert in SQL and DB Server. Please give us the opportunity to work on this Project. Please message me for further communication. We will check the demo first and then you award us the project !!

$222 USD v 3 dnech

2,8

(2 recenze)

4,1

@sidhidhall

Hey there, As you are looking for an MYSQL expert for fixing the issues of Query Performing Slowly so I am expert in it and I can start right away let me know if you have any queries. Thanks Sidhi

$250 USD v 4 dnech

4,0

(1 recenze)

2,3

@skavras

Hello, I will be glad assist you. I'm good in databases (was a team member of MS SQL Srvr 2005, now mostly work with Postgres 9x, MariaDB/MySQL and MSSQLSrvr14) so think can provide good effort on this :). Could we please make a short chat/call to discuss the task in details. I'm available from 10 AM to 8 PM UTC. Sincerely, Sergii

$133 USD v 3 dnech

5,0

(1 recenze)

0,5

@sayyedraish

Problem statements:: performance optimization for MySQL queries Propose solutions:: MySql is very fast in performance compare to other RDBMS. however because some poor design structure the query started taking more time and sometime throw exception. for solution we need to optimize table add proper constraints and indexes. also using some external tool like caching. we can optimize query.

$333 USD v 10 dnech

0,0

(0 recenze)

0,0

@syedtausif1

I have extensive experience in Database and have designed multiple large systems where large data is processed. Please share ERD it will be helpful in solving slow query issue. thanks

$133 USD v 5 dnech

0,0

(0 recenze)

0,0

@naineshpatil87

-__________________I can fix your Problem____________________________________ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$155 USD v 3 dnech

0,0

(0 recenze)

0,0

@samuelvella

Hi Sounds like an interesting problem! Hopefully it can be solved by fixing the query, I should warn you though that it may be an underlying problem with the database design not being aligned to business requirements in which case some other remedial action may be needed to improve performance. I've got almost 20 years of database and SQL experience and have spent many an afternoon rewriting poorly performing queries! A couple of questions for you: Would you be able to send me one of the queries so I can see what I'd be dealing with? What scope is there for making changes to the database? E.g. New indexes and tables? Will I have access to the database itself? Or at least willI be sent the DDL for the tables and all associated indexes, primary and foreign keys. Thanks Sam

$155 USD v 3 dnech