完了

FIX mysql 1 query ORDER BY ISSUE

Hi Freelancers,

I have a quick fix issue on mysql.

I have a query which is taking data from 5 tables using inner join and it is working fine and its response time is0.1766MS.

The problem is when I add "Order By" clause on two columns in the same query it takes 6 Seconds to response.

It seems some Indexing problem.

I am sure this is a 15 minutes task for true developer.

Please only bid if you are a developer and can fix it right away.

I will give you the database access the all you will have to do is find the issue and fix it.

スキル: データベースアドミニストレーション, MySQL, SQL

さらに表示: fix mysql query, fix mysql cpu load issue, fix mysql query error, 2013 lost connection mysql server query php, fix mysql errors, mysql update query, insert table lost connection mysql server query, php mysql update query, mysql csv query, advanced mysql search query, lost connection mysql server query, mysql asp query problems, 2013 lost connection mysql server query, mysql load query php, mysql search query

採用者について:
( 6件のレビュー ) Rancho Palos Verdes, United States

プロジェクトID: #16037492

アワード:

AndreyBarykin

Have big expirience as Senior Database Developer. Know well sql and query optimization(also via indexes). Fast and good result.

$12 USD 1日以内
(2レビュー)
2.2

29人のフリーランサーが、このジョブに平均$23で入札しています

uhjk

Hello, Did you try to put INDEX for database column? It should faster query. I can add it if you don't know how to do.

$25 USD 1日以内
(274件のレビュー)
7.1
hjr122413

Hi Thanks for your posting. I am so experienced in relational database, if you would hire me, I can finish this task perfectly. Let's discuss more in detail via chat. Best regards. Chengzhe.

$30 USD 1日以内
(37件のレビュー)
6.1
softcarve

Hi, I would like to solve the indexing problem for order by clause. please get in touch to discuss more. Regards, Manish

$25 USD 1日以内
(55件のレビュー)
5.4
enriquethumar

I have 8+ years experience in web / ios fields,and 3+ years of experience in private company having 500+ employee as a Technical Team leader . My expertise are : php , drupal , wordpress , joomla , magent もっと

$25 USD 1日以内
(15件のレビュー)
5.3
imagicaworld

Hi We understand your requirements and our aim is to analyze your requirements in a logical way and give you the perfect solution. Please check my expertise [login to view URL] Waiting for your kin もっと

$50 USD 1日以内
(17件のレビュー)
5.2
hjvasoya

Hello, I'm well Qualified & Professional Web Developer having 4+ years of experience in developing quality Websites that are very much active in the market today. My knowledge, technical skills and attributes lie もっと

$15 USD 1日以内
(21件のレビュー)
4.5
JamesTechnology

Hello there, i am ready to fix the the order issue in mysql. please message me so i can discuss with you. Thanks

$25 USD 1日以内
(12件のレビュー)
4.4
albertgaya

Looking forward working on this もっと

$15 USD 1日以内
(3件のレビュー)
3.6
poojamishra13

Hi there, I am expert developer. I can fix this query. Please share with me db details.

$25 USD 1日以内
(10件のレビュー)
3.8
amraltweky

I have solid experience in Writing SQL Queries send me your db access and query and i will check query tables and its indexes

$20 USD 0日以内
(4件のレビュー)
3.5
hitech10

Dear Client , I am IMMEDIATELY AVAILABLE for discussion and will be able start resolving the issue Right Away upon hiring. About me : With more than 10 years, I am an expert Web developer and Till now I have d もっと

$24 USD 1日以内
(2件のレビュー)
3.1
reedsystems

Hi, I read your request. You are probably right in your assertion, adding the order by to queries may affect the performance. No worries though, I can review the query and perform the required optimization.

$25 USD 1日以内
(5件のレビュー)
3.2
DigitalRace

Hello! I am an expert in web development and have 10 years of experience. I majored in Mysql query. Please contact me, you will get a wonderful result. I will wait for your reply. Thanks.

$25 USD 1日以内
(5件のレビュー)
3.1
hadiachaudary

I have 4+ years experince in Web Developer/Designer in Wordpress with ccustom development and With Having Good Interpersonal & Communication in English.I have checked your requirements and i am able to help you for the もっと

$25 USD 1日以内
(4件のレビュー)
2.5
zhiqiang1988

Dear sir. I am a DB expert. If you hire me, I will give you excellent results with a small amount of money in the shortest time. I hope to meet you again. Thank you.

$15 USD 0日以内
(4件のレビュー)
2.2
$25 USD 1日以内
(2件のレビュー)
1.2
phoniex7

I've 8+ years experience in Analytics industry. Worked on Excel, SQL, SAS and Big data extensively. Expect a Error free, on-time, good quality delivery from my side.

$20 USD 0日以内
(0件のレビュー)
0.0
jorgepaps

A proposal has not yet been provided

$30 USD 1日以内
(0件のレビュー)
0.0
$25 USD 1日以内
(0件のレビュー)
1.6
ashokdzpxq

add the index for both the cloumns you are adding in order by .. I can work for that I can work on your project , I have 10 years of IT experience in development . Kindly please have a look on my profile

$25 USD 1日以内
(0件のレビュー)
0.0