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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-10-08 : 12:26:42
|
| Did yukon enhance the usability of images?Or is it still painful?Brett8-) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-08 : 20:08:33
|
| They've added varchar(max) and binary/varbinary(max), which allow the same storage capabilities of text and image, but they operate the same way as binary and varchar do. So it's more convenient to program at least. The CLR integration will let you manipulate images very easily. As to whether it's a good idea to store them in the database, I would still lean towards "no", however, there are other enhancements to the way databases are stored that might make it more viable than it is currently. You'd still be stuck with storing 8K of data on a page, with the unused space wasted, whereas storing as files on the filesystem would be far more efficient, especially for small (<1K) images. And in a web application, it is still less efficient to pull images from the DB than it would be to have the web server serve them as regular files. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-10-11 : 12:24:55
|
| Thanks...good points....Brett8-) |
|
|
|
|
|
|
Image handling in express