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 |
FruitBatInShades
Yak Posting Veteran
51 Posts |
Posted - 2006-07-21 : 08:23:54
|
Does keeping the text field in a different table help performance?I am working on a website system that has page content in text fields, some of which are quite big. I keep creating seperate tables for the text in the hope that it will improve performance. The reason being that the main table is scanned and filtered a lot.Does SQL server keep the text content seperately anyway? Am I gaining anything using this approach? |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-21 : 08:36:50
|
Depends on the text in row setting. Look at sp_tableoptionLook at text in row in bol.==========================================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. |
|
|
FruitBatInShades
Yak Posting Veteran
51 Posts |
Posted - 2006-07-26 : 04:50:45
|
So by default SQL Server keeps blob info in a seperate place. So by creating seperate tables like (Page,PageContent) and joining at query time, I am gaining anything in performance? |
|
|
|
|
|