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 |
|
Shiva808
Starting Member
6 Posts |
 Posted - 2007-01-23 : 16:47:36
|
| Hi,We have a large database table with an IMAGE field holding documents of < 1MB size.Over time this table has become quite large and operations on it have become slow.My question is, would changing from IMAGE to varbinary(max) make the binary storage more efficient thereby making the table operations faster.Also, would the table size be smaller with varbinary(max)?ThanksHope I got the correct forum this time lol. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-23 : 17:19:29
|
| It probably won't make much difference. If the values in the columns are more than about 8K in size (possibly quite a bit less depending on the size of the rest of the columns in the table) then they are going to be stored outside of the table pages just like they are with image. If a large percentage of the values are much smaller than about 8K then it may improve performance because the values will be stored in the rows.The design of your table, the indexing, and the maintenance of the indexing is probably going to have much more impact on performance. Are you regularly updating statistics and rebuilding the indexes, do you know how to optimize queries and so, this is where you'll get improvements. |
 |
|
|
|
|
|
varbinary(max)