I need an expert in MySQL for optimizing a list of queries and a database for performance.
I have about 500 queries and 68 tables. I need 3 things:
1. First thing is to check those queries for optimizations (though most queries are too simple for optimization).
2. The second (and most important) thing is to check the tables and queries and create suitable indexes for improving performance.
3. And finally I'd like you to suggest other possible improvements, e.g. field types and other stuff based on the existing tables and queries which can improve performance and reliability of the database.
Some experience with .NET is a plus, since the queries are in vb.net files and you need to be able to understand those.
In your bid or PM please let me know how you will approach the project.