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-22 : 23:12:02
|
| 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)?Thanks(ps sorry for the cross post) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-23 : 01:07:30
|
| If you know you are crossposting and you are sorry about that, why do you crosspost?Peter LarssonHelsingborg, Sweden |
 |
|
|
Kristen
Test
22859 Posts |
|
|
Shiva808
Starting Member
6 Posts |
Posted - 2007-01-23 : 16:42:23
|
quote:
Originally posted by Peso
If you know you are crossposting and you are sorry about that, why do you crosspost?Peter LarssonHelsingborg, Sweden
Well, you see I'd already made the post to the wrong forum... Jeez mate it ain't the end of the world so get a grip pls lol |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-24 : 08:42:06
|
| "Jeez mate it ain't the end of the world so get a grip pls"Well it is if you see it from my perspective:I have limited time, and try to help folk with problems here.I get annoyed if I answer a question in one forum only to find that it has been posted in a different forum, and already answered, as I could have spent that time helping someone else.Other folk here give their time for free similarly, and also don't like to find their time wasted.So that's why we don't like duplicate/cross posts.Kristen |
|
|
|
|
|
|
|
|
varbinary(max)