469,579 Members | 1,102 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

New SQL Server and Photos

I heard that you can store photos with the row in the new SQL Server (a
photo data type?). Is this true? If so, is there a speed advantage if
you have an e-commerce platform with thousands of products?

Help appreciated.
Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #1
2 1207
I'm not sure what you're referring to - MSSQL already supports the
image data type for storing up to 2GB of binary data in a row (which
could be photos or anything else).

Although I haven't worked with a system like that myself, previous
newsgroup posts seem to suggest that many people prefer to store only a
path to the binary file in the database, and leave the file itself in
the filesystem.

Simon

Jul 23 '05 #2
> Although I haven't worked with a system like that myself, previous
newsgroup posts seem to suggest that many people prefer to store only a path to the binary file in the database, and leave the file itself in
the filesystem.


That's been my approach. The file system's on the whole a much more
efficient way to deal with such things, provided you've guarded against
path-traversal security problems and the like. For one, you're
funnelling less data through SQL Server itself, and two, NTFS is built
to handle exactly this kind of work in the first place.

There may be some circumstances where you need to have the data in the
row -- I think TerraServer uses this approach -- but most people are
not going to be building TerraServer!

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.