Reputation: 1838
I have a web application written in asp.net/c# I want to know which one (save image in database or on hard disk) has better performance, security and flexibility
Thank you
Upvotes: 2
Views: 1432
Reputation: 239824
One option to consider, if your version of SQL Server supports it, is FILESTREAM
FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data.
This lets you keep the files on disk, but maintains transactional consistency with other data that you're storing in the database.
Upvotes: 5