MySQL Forums :: Database Design & Data Modelling :: Design approach for summary table by 3 items


Advanced Search

Design approach for summary table by 3 items
Posted by: Miro Vvv ()
Date: January 30, 2009 08:49AM

Hello everybody,
I'll need opinion for best approach to design summary table by visits grouped in hours, pages, visitors
I've made few calculation and I discover that i have a problem

I need to collect data for some login visitors (impression) per page for each hour
...so for 1 year this table will increase horrible.

Example: (impression, date round to hours, visitors, pages)
-8760 hours for a year
-1000 visitors
-500 pages

Total rows per year is more then 4 billion rows. The problem consists if I decide to do the table per month but in smaller scale witch make me think that is not the right approach for this purpose. Any help will be appreciated. Thanks in advance.



Edited 1 time(s). Last edit at 01/30/2009 08:55AM by Miro Vvv.

Options: ReplyQuote


Subject Written By Posted
Design approach for summary table by 3 items Miro Vvv 01/30/2009 08:49AM
Re: Design approach for summary table by 3 items Rick James 01/31/2009 11:23PM


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.