MySQL Forums
Forum List  »  Data Warehouse

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

Written By
Re: Dimensional model, user ids and number of tables
June 26, 2009 07:17AM

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.