MySQL Forums
Forum List  »  Data Warehouse

Re: Dimensional model, user ids and number of tables
Posted by: Rick James
Date: June 25, 2009 09:15PM

20K tables is pushing things. I recommend against that approach.

50M rows, even with a compound primary key, is big, but not impossible. Remember, indexes are in BTree format, which grows only as the log of the number of rows.

Let's get into what the 10K-100K rows are for each user. Having to fetch that many rows will take a noticeable amount of time, regardless of the structure. And, if you have to join that many rows between two tables, it will be seriously slow.

PARTITIONing is unlikely to help any. Sharding could, but that involved more hardware.

Options: ReplyQuote

Written By
Re: Dimensional model, user ids and number of tables
June 25, 2009 09:15PM

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.