Hay, we are looking for someone who can help redesign the database. If any one is able to help out with this and has experience with MySQL database design please PM me on the forums here or ping me on Twitter.
Here is a overview of what we are looking to do
Code:
Change all tables from myisam to innodb (For row locking vs table locking and Foreign key support.)
Create Foreign keys to get rid of all data dups.
Recreate any indexes that were broken due to the new keys.
Help come up with a higher performance layout???
TBH I am not a database designer so past those requirements I do not know what else we might need.
__________________