I am looking for an MySQL 5 guru to assist with script (transact SQL) review.
This is not a complex task - it is basic SQL with simple CREATE TABLE scripts.
Its a small project and would take maximum of 2 hrs to complete -
The aim of the project is ensure our MySQL structure/tables and overall settings are best for performance/scalability.
You must be very experienced with MySQL 5 and have an indepth understanding of SQL statements, indexes, table joins, performance issues, server settings.
Database currently has app. 30 tables. Records in larges table may reach into millions, other tables are a lot smaller.
Platform: Windows Server 2003, MySQL 5