i have a question about key & column design.
in my application we have 3,000,000,000 record in every day
each record contain : user-id, "time stamp", content(max 1KB).
we need to store records for one year, this means we will have about
1,000,000,000,000 after 1 year.
we just search a user-id over rang of "time stamp"
table can design in two way
1.key=userid-timestamp and column:=content
2.key=userid-yyyyMMdd and column:HHmmss=content
in first design we have tall-narrow table but we have very very records, in
second design we have flat-wide table.
which of them have better performance?
Jerry Lam 2012-10-10, 16:55
Doug Meil 2012-10-10, 17:09
Jerry Lam 2012-10-10, 19:08
Shumin Wu 2012-10-10, 19:51
yutoo yanio 2012-10-11, 08:27
Anoop Sam John 2012-10-11, 09:10