Hi I have a big, 10 lines mysql query
using 5 tables
and well it isn't exactly slow but i'd like to know if it can be optimized
in order to be immediate.
Currently it takes 0.899 sec to run
with 20M rows on the biggest table.
That's decent but I wonder if by playing with the indexes or the data organization it can be lowered to 0 sec :)
Warning: this is quite an headache so please bid only if you are a seasoned dba expert :)
I can efficiently help with performance troubleshooting and improvement because I am Senior SQL Developer with 10+ years of advanced development experience and exceptional expertise in professional SQL development and tuning.
€140 EUR en 2 días
5,0
(36 comentarios)
5,2
5,2
14 freelancers están ofertando un promedio de €130 EUR por este trabajo
Hello, I would like to help you, I have more than 10 years of experience working with MYSQL, POSTGRESQL, SQL SERVER, MARIADB, in many of its versions. It is my specialty en SQL y PL/SQL.
Hello! I am a career software and database developer who has been working daily with SQL databases for the last 10 years.
I most likely can help to optimize your query. No charge if I'm unable to make a significant improvement.
Please message me with details.
Thanks,
John M
Hi. there, As a mysql expert, I'm interested in your project.
You want me to optimize the run time?
Avoid using functions in predicates
Avoid using a wildcard (%) at the beginning of a predicate
Avoid unnecessary columns in SELECT clause
Use inner join, instead of outer join if possible
Use DISTINCT and UNION only if it is necessary
The ORDER BY clause is mandatory in SQL if you expect to get a sorted result.
I can do it as this way.
I hope we can go into more details when we chat.
Thanks.
Shateev.
MASTERS IN SOFTWARE DEVELOPMENT AND ARCHITECTURE.
EXPERT IN C, C++, PYTHON, JAVA AND PHP, BOT MAKING AND SCRIPTING, AUTOMATION.
Hi there!
Thank you for sharing your project requirement, I have carefully read the project description and I would like to take part in this project. I hope you will benefit from my services I can assurance that I will live up to your expectations.
CHEERS.
Hello. Are you well?
I have huge experience in Mysql and have already built a lot of projects before.
Having the required skill, I would be glad to help you.
I have 5 years of strong experience in web design and development.
Please review my profile to find required information about me.
Hope to response from you soon.
I'm ready whenever you are.
Thanks.
Dear, Client
I mastered skills with Node js, SQLLite, Perl,Mobile APP development, php,.
I think code analysis is important in this project.
If you have mind to hire me, I'd like you to send source quickly.
I'll wait for your answer.
I am Data Engineer with 3+years of experience in database administration and cloud technologies. According to your requirement you require Sql query optimization which can be done using the best practices for query optimization.
lets connect and discuss the query .