Quote: if your pictures or document are typically below 256K in size, storing them in a database VARBINARY column is more efficientif your pictures or document are typically over 1 MB in size, storing them in the filesystem is more efficient (and with SQL Server 2008's FILESTREAM attribute, they're still under transactional control and part of the database)in between those two, it's a bit of a toss-up depending on your use
if your pictures or document are typically below 256K in size, storing them in a database VARBINARY column is more efficient
if your pictures or document are typically over 1 MB in size, storing them in the filesystem is more efficient (and with SQL Server 2008's FILESTREAM attribute, they're still under transactional control and part of the database)
in between those two, it's a bit of a toss-up depending on your use
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip