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: Mads Jensen ()
Date: June 26, 2009 07:17AM

Thank you for your answer.

I might have explained the number of rows wrong. 10k-100k was the number of rows each user would have in the database. Each query would target anything from 5-50 rows for each request.

My concern is due to having to place a user id with each row. So not only would i have to join on the surrogate keys, but also be required to have a " && user_id='11'" in each query to make sure requests are not made on rows that don't belong to the particular user.

From what i read about how InnoDB works, it's recommended to have the surrogate key as the first cell in the dimensions to get the best performance.



Edited 2 time(s). Last edit at 06/26/2009 07:19AM by Mads Jensen.

Options: ReplyQuote


Subject Views Written By Posted
Dimensional model, user ids and number of tables 7964 Mads Jensen 06/24/2009 01:07PM
Re: Dimensional model, user ids and number of tables 3845 Rick James 06/25/2009 09:15PM
Re: Dimensional model, user ids and number of tables 3634 Mads Jensen 06/26/2009 07:17AM
Re: Dimensional model, user ids and number of tables 3686 Rick James 06/27/2009 12:24AM
Re: Dimensional model, user ids and number of tables 3611 Mads Jensen 06/30/2009 12:48PM
Re: Dimensional model, user ids and number of tables 3652 Rick James 06/30/2009 10:00PM
Re: Dimensional model, user ids and number of tables 4270 Mads Jensen 07/03/2009 04:20AM
Re: Dimensional model, user ids and number of tables 3522 Rick James 07/03/2009 02:21PM
Re: Dimensional model, user ids and number of tables 3547 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.