danarj
danarj

Reputation: 1838

Saving image in SQL Server or on disk

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

Answers (1)

Damien_The_Unbeliever
Damien_The_Unbeliever

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

Related Questions