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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-11-14 : 23:41:00
|
| hello everybody.could anybody suggest me what is the good practice when storing image files into the sql server database.'storing the image path or storing the image in a binary format'. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-11-15 : 00:24:11
|
| It depends upon your requirement!The simple and easy method is store the image path, But you must make sure the physical file!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-15 : 00:43:28
|
| thanx for your reply. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-15 : 04:53:27
|
| We store Path / Filename.We do not want all our FULL / DIFF backups increased by the size of the images. Using filesystem we can have a variety of archiving-backup strategies.I think performance is better getting images from filesystem, rather than from database, and greatly probability of the Client caching the image.#If it was critical to me that the Image was synchornised with the data (i.e. I could add, or change, Image and Data record within a single transaction) then storing them in the database would enable me to do that. If I had to move Data and Images to other servers then maybe using database would be easier.But the huge size of database and inflexibility of backup would be a major concern to me. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2010-11-15 : 05:00:30
|
| I would say it depends on the number/size of the images. For most cases the path/filename is probably the best option for the reasons Kristen has given but then you have manage the files yourself.-----------I used to think I wasn't a morning person but it never got better in the afternoon |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-15 : 05:38:41
|
| thanx for all your inputs |
|
|
|
|
|
|
storing image in the database