Hi,
I'm looking for someone to rewrite the SQL queries so that they create minimum amount of tmp tables.
There is a huge number of queries which are creating temporary tables in my 2 sites which is causing the MySQL to crash.
This is just a little work and you will get access of the sites.
Thanks
Hi I am a MySQL expert of the highest calibre. I will rewrite the queries to be the most efficient possible and least memory intensive. Please see PM for confidential details.
Hi there,
Can you please share the server details so i can go through the queries and make the changes.
I will take care that i will not break anything and not harm any existing working stuff while refactoring the queries.
Hi,
I have 5+ yrs of DWH experience. Please share the SQL's / location of the sqls to be tuned.
Putting 2 days due to time differences we might have. Be assure of the quality.
Thanks,
Amit
I would like to be considered for this project. I am an honours graduate in Software Engineering and have over 10 years professional experience in Database design and development and am an expert in SQL, VBA and office applications.
I am especially skilled in troubleshooting, redesigning and optimizing SQL queries. I am sure I can resolve your problems quickly.
Hope to hear from you.
I have >10 yrs experience writing PL/SQL in Oracle and MSSQL. Some of those deal with complex calculations (commission calculation, meter charge calculation).
If your system is of similar complexity, do consider me!