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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2010-04-21 : 21:30:02
|
| better to use several table or one long tableQuestion: Graded assignments. I have 100's of college sections each academic year and each has tens of assignments and 800 students per academic year.Design and performance wise is it better to have one table for all sections and its students or a table for each section. sarah |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-21 : 21:36:20
|
Single table. Else who is going to create the table whenever user create a new section ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2010-04-22 : 19:02:10
|
| Creating a table can be automated (by code). But performance wise which is bettersarah |
|
|
|
|
|
|
Forum db structure