March 28, 2009 at 10:14 am
I am exploring the option of moving 15mill tiff images into SQL Server 2005 database. What are
the pros and cons of string images in SQL Server 2005 as opposed to file system. Are there
any article or white papers suggesting the pros and cons?
March 28, 2009 at 11:11 am
Hi there,
The deciding factor will be determined by the size of your image files.
If they are relatively small in size i.e. less than 1MB then storing within the database is absolutely fine.
Larger than this and it becomes more appealing to store files to the file system. This is because of the relative low cost of storage and the fact that you can place the files on lower grade storage than say your high performance disk subsystem used for your OLTP database. This will also avoid bloating your database but has the downside of requiring backups external to SQL server in order to cover all data for your solution.
The following article provides a more detailed discussion for your reference.
I hope you find this information useful but do please feel free to contact me directly if you require further assistance.
http://research.microsoft.com/apps/pubs/default.aspx?id=64525
Cheers
March 28, 2009 at 11:31 am
15 million Tiff files should be moved to SQL Server 2008 so you can use the file stream feature because if you use 2005 you may have to store your files in file system instead of SQL Server. The reason the new file stream was created to take care of such needs.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply