View Single Post
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
Old 07-16-2013 , 17:10   Re: HLstatsX:CE News
#10

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.
__________________
Mavrick4283 is offline