Table for each region in MySQL

Posted by King Wu on Stack Overflow See other posts from Stack Overflow or by King Wu
Published on 2012-12-07T10:25:12Z Indexed on 2012/12/07 11:04 UTC
Read the original article Hit count: 224

Filed under:
|
|

There are four regions with more than one million records total. Should I create a table with a region column or a table for each region and combine them to get the top ranks?

If I combine all four regions, none of my columns will be unique so I will need to also add an id column for my primary key. Otherwise, name, accountId & characterId would be candidate keys or should I just add an id column anyways.

Table:
----------------------------------------------------------------
| name | accountId | iconId | level | characterId | updateDate |
----------------------------------------------------------------

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql