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 8107 Mads Jensen 06/24/2009 01:07PM
Re: Dimensional model, user ids and number of tables 3916 Rick James 06/25/2009 09:15PM
Re: Dimensional model, user ids and number of tables 3710 Mads Jensen 06/26/2009 07:17AM
Re: Dimensional model, user ids and number of tables 3752 Rick James 06/27/2009 12:24AM
Re: Dimensional model, user ids and number of tables 3689 Mads Jensen 06/30/2009 12:48PM
Re: Dimensional model, user ids and number of tables 3716 Rick James 06/30/2009 10:00PM
Re: Dimensional model, user ids and number of tables 4327 Mads Jensen 07/03/2009 04:20AM
Re: Dimensional model, user ids and number of tables 3590 Rick James 07/03/2009 02:21PM
Re: Dimensional model, user ids and number of tables 3600 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.