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 |
|
nick9
Starting Member
1 Post |
 Posted - 2003-10-12 : 13:54:24
|
| Hello all,I wanna write a news project (news manager) , nowdays I'm confused with DB design for it!User can create new categories,I know If I save all categories in one table, It will be busy and not good.So when user create a new category, I save the category name with an id in a table named tables,then I create a new tablefor the category, it has these columns: (id,subject,description,ect.)Now each category has a separate table, and when user add a news to a category i will add it to it's table.and my questions are:1-in this DB design, what about when I wanna do a search in all categories for subject and description or date? It will be slow,right? and how can I do that?2-can anyone give me a better alternative for my DB Design?3-Do you know some advice stuff like article or ect for writing a News Manager?Thanks in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-12 : 14:08:38
|
| Don't create a separate category for each category. The single table will be a lot easier to administer. Creating a new table and the required dynamic sql will put a lot more load on the server than accessing the single table as well as causing security problems.Tables are meant to be permanent and should not be created dynamically.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
db design help