Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
irs2k3
Starting Member
22 Posts |
 Posted - 2009-09-14 : 09:57:43
|
| Hi guys,I am creating a news portal that will contain lots of Main categories Like News, Articles, Videos, Music etc... Each category will contain of course sub-categories.I was thinking of creating for each category a Table. For news I create like dip_News, for Articles dip_Articles...That way each main category is splitted into its own table. Any ideas on how to better manage this? taking into consideration searching and be able to handle large data volumes in the future?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-14 : 10:46:11
|
quote:
I was thinking of creating for each category a Table
Don't.Add a Category column to your main news item table. Create a Categories table to track each category, and include a ParentCategory column to hold that category's parent for hierarchical purposes. |
 |
|
|
irs2k3
Starting Member
22 Posts |
Posted - 2009-09-14 : 11:51:01
|
| Hi robvolk,Thanks for your suggestion. Yes, I was thinking of that. But will this heart performance. I mean instead of querying a table with 2 million record. I am querying it with like 200.000 records if categories where splitted into tables.Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-14 : 13:20:53
|
| It will not hurt performance if you index the Category column in your news table. Performance is more affected by the number of rows being returned in a query, not by the number if the entire table. |
|
|
|
|
|
|
DataBase Architecture suggestion