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.
Được trao cho:
27 freelancer đang chào giá trung bình $23 cho công việc này
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.
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.
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.