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.
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.
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.
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.
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.
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