Skip navigation links

MySQL Forums :: Data Warehouse :: Dimensional model, user ids and number of tables


Advanced Search

Re: Dimensional model, user ids and number of tables
Posted by: Rick James ()
Date: July 03, 2009 02:21PM

Still sounds good.

With InnoDB and the PRIMARY KEY starting with `user_id`,`month_key`, the data for the queries you mention will be "clustered". That is, you won't hit the disk very often (on the order of 100 rows per disk hit). So the SELECTs should run pretty fast.

Options: ReplyQuote


Subject Views Written By Posted
Dimensional model, user ids and number of tables 8064 Mads Jensen 06/24/2009 01:07PM
Re: Dimensional model, user ids and number of tables 3896 Rick James 06/25/2009 09:15PM
Re: Dimensional model, user ids and number of tables 3691 Mads Jensen 06/26/2009 07:17AM
Re: Dimensional model, user ids and number of tables 3740 Rick James 06/27/2009 12:24AM
Re: Dimensional model, user ids and number of tables 3672 Mads Jensen 06/30/2009 12:48PM
Re: Dimensional model, user ids and number of tables 3698 Rick James 06/30/2009 10:00PM
Re: Dimensional model, user ids and number of tables 4317 Mads Jensen 07/03/2009 04:20AM
Re: Dimensional model, user ids and number of tables 3574 Rick James 07/03/2009 02:21PM
Re: Dimensional model, user ids and number of tables 3588 Mads Jensen 07/04/2009 03:20AM


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.