Đã hoàn thành

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.

Kĩ năng: Quản trị cơ sở dữ liệu, MySQL, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 19 nhận xét ) Rancho Palos Verdes, United States

ID dự án: #16037492

Được trao cho:

AndreyBarykin

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

$12 USD trong 1 ngày
(3 Đánh Giá)
3.3

27 freelancer đang chào giá trung bình $23 cho công việc này

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 trong 1 ngày
(367 Nhận xét)
7.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 Thêm

$50 USD trong 1 ngày
(32 Nhận xét)
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 trong 1 ngày
(94 Nhận xét)
5.9
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 Thêm

$25 USD trong 1 ngày
(19 Nhận xét)
5.6
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 trong 1 ngày
(13 Nhận xét)
5.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 trong 1 ngày
(19 Nhận xét)
4.8
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 Thêm

$15 USD trong 1 ngày
(25 Nhận xét)
4.5
albertgaya

Looking forward working on this Thêm

$15 USD trong 1 ngày
(5 Nhận xét)
3.7
poojamishra13

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

$25 USD trong 1 ngày
(13 Nhận xét)
3.9
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 trong 0 ngày
(4 Nhận xét)
3.7
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 Thêm

$24 USD trong 1 ngày
(2 Nhận xét)
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 trong 0 ngày
(6 Nhận xét)
2.9
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 Thêm

$25 USD trong 1 ngày
(4 Nhận xét)
2.5
$25 USD trong 1 ngày
(2 Nhận xét)
1.2
$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
1.6
vasankarthi

HI i am a web developer and designer please contact me for discuss further details about project i will completed your project Thanks

$20 USD trong 1 ngày
(0 Nhận xét)
0.5
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 trong 0 ngày
(0 Nhận xét)
0.0
jorgepaps

A proposal has not yet been provided

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
$15 USD trong 1 ngày
(0 Nhận xét)
0.0