MySQL Forums
Forum List  »  Data Warehouse

Re: Dimensional model, user ids and number of tables
Posted by: Rick James
Date: June 30, 2009 10:00PM

Nothing obviously wrong.
What will the SELECTs look like?
10M rows? That should be manageable.
If there are only a few "measures", the table size will be about 3GB? The secondary index will be more like 1GB? Again, manageable.
All the data about one user will be "clustered", but may occupy 2MB. This is still manageable if you have to scan all the rows for one user. (But you can't do that too often without having performance issues.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Dimensional model, user ids and number of tables
4590
June 30, 2009 10:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.