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
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