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.
14 freelance font une offre moyenne de $182 pour ce travail
Hello, I have much of experience with SQL performance optimisation and can take part on your project with a great pleasure.
10 plus years of query database / query optimization with experience in MySQL, Oracle and SQL Server. My approach will be to look through the queries to weed out the simple queries and focus on the complex (i.e. th Plus
Hello sir, we are part of the team which is providing support to the Barclays bank U.K. Our team gained 3yrs+ experience in the software industries and we will deliver the project with all deliverable requested by yo Plus