On 11/21/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>I've read about saving images as BLOBs inside MS-SQL. Are there any > advantages or pitfalls to doing it this way? > > It is generally not considerd as a good idea to use a database to store > images. > The file management system in the operation is also a kind of database, > especially made to store > and retreive files. > The reason database systems have been designed is that they allow for > information searching and sorting. > But there is nothing to search and sort in an image, so the file > management system is much better suited for this > kind of task. > Using the database engine will just have a bad impact on the overall > performance, for no advantage. >
I wouldn't say that there's no advantage. Having one database with all the image data could easily be used by two or more servers. The best solution imho, albeit the largest disk space, would be to have images stored in the database with caching provided by the file system. Especially if you have a lot of images being uploaded or modified. This way, you have your source code backup and you have your database backup. Should your server fry, you don't also have to have an image folder backup also. > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224844 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
