完了

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, mysql order by field, mysql order by multiple, mysql sort by date, mysql order by limit, mysql order by desc, mysql order by index, mysql order by not sorting properly, mysql order by varchar, mysql, sql, database administration, 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

採用者について:
( 7件のレビュー ) 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

28人のフリーランサーが、このジョブに平均$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日以内
(302件のレビュー)
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日以内
(43件のレビュー)
6.4
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日以内
(65件のレビュー)
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日以内
(19件のレビュー)
5.2
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
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日以内
(25件のレビュー)
4.5
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日以内
(16件のレビュー)
4.2
albertgaya

Looking forward working on this もっと

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

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

$25 USD 1日以内
(10件のレビュー)
3.7
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
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日以内
(6件のレビュー)
3.0
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
$25 USD 1日以内
(2件のレビュー)
1.2
ebonnevi

I'm a DBA at Canada governement. I can surely help you! You can contact me via email, sms, google chat or the way you want

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

i got the answer from searching .....................................................................................................

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

Hello, I am from morocco, I can offer a high quality work (SQL programming, which I learned in databese courses in my university). My goal is your satisfaction! I really have the pleasure to work with you and help you もっと

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