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 |
|
spentun
Starting Member
1 Post |
 Posted - 2012-03-03 : 04:42:31
|
| I wanna design a forum. I create two table A and B.A: UserID: save user ID Birthday: user's birthdayB: PostID: the number of the posting Content: the content of the posting or reply Owner: the creator or the person reply the article , it FK map to Table A:UserID IsReply: this will be true if the content is be replied. A huge data be posted everyday. Table B increases quickly. The performance will be lower. How should I resolve the issue? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-03-03 : 05:17:45
|
For your homework question,1. Use compression if on Enterprise Edition.2. Use partitioning if on Enterprise Edition.3. Create proper indexes.4. Do you really need unicode?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
A huge Data In same table