April 10, 2010 at 2:34 pm
I am trying to build a small e-commerce website that will allow user to upload and store the image of their product in the database and also the user could upload the image of the product and compare it with all the similar product images that are already stored in the database.
I am using MS .Net as the front end.
So please let me know if MS SQL server is the best option to carry out such task or should I consider some other database to do this in terms of complexity involved as well as the integration with MS .Net framework.
I am new to databases so please explain in detail how to approach and which db to use.Thanks!!
April 11, 2010 at 1:00 am
SQL server can handle this but typically you will have far better performance if you store the images to a file system instead of in the database. Oracle also can handle this but you are talking about much higher costs for Oracle and the end result is you would still want to keep the image outside of the database. SQL server 2008 and > have made strides as to how it handles images and is worth testing if you absolutly need to save it to the database. Your total costs will be significantly lower than Oracle.
April 11, 2010 at 10:05 am
JDixon-385826 (4/11/2010)
SQL server can handle this but typically you will have far better performance if you store the images to a file system...
It rather depends - mostly on the average size of the images. The emerging 'rule of thumb' appears to be that VARBINARY database storage is optimal up to 256KB, and FILESTREAM is optimal over 1MB. Between those sizes, more complex considerations must be taken into account.
See FILESTREAM Storage in SQL Server 2008
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply