which is better, storing images in database or storing it in the file system (saving only the path of the images in the database).
Store images in db or in file system.
Hot Topic
- Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)
- New SQL Database?
- Replication Isues After upgrading subscriber to 2005
- Data format conversion.
- SQL 2005 Database Engine setup failure
- environment variables
- Problem with numeric formatting
- How to findout if the column is Unique or Key?
- How to turn off logging
- Set limited to 4,294,967,296 tuples
SQL Server
- SQL Mobile Server Tools install on SQL 2000 SP4
- How to Copy DataBases between SQL Express instances.
- Connection Pooling on Analysis Services
- Replication sample program
- Reporting Service design for SOA based application
- Enterprise Manager Error
- Decimal formatting
- How to view sample transformed data before loading it into the table
- Syntax for "In" Operator
- String truncate error
Store images in db or in file system.
Peter Torr - MSFT
Hi,
that is (and I don’t hope that you started it right now) a religious war. I think files have to be stored on the file system (unless WINFS is launched). If you want to fulltext index them and search them though the database then you’d better store them in the database and keep use ofthe FT functionlities in SQL Server. Are the file small or big, how many files are you expecting, how do you want to extract them from the database. perhaps you build something like a generic interface which passes back a stream and which can be exchanged with either a fileconnector or a database connector.
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---