Click here to Skip to main content
13,352,879 members (65,174 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
In A project Needed to save the scanned image. Please guide Me What volume of files Can stored in Sql Server database(2005 AND 2008) That not lower speed OR You Have better suggestion?
Posted 16-Dec-13 10:30am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

It's pretty hugs, but it depends on which version of SQL Server you have - the Express version for example is generally restricted.
The "Normal" limits are here: http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx[^] - there is a drop down for the different versions 2008R2 / 2008 / 2005

But...you will start to use server bandwidth pretty quickly if you aren't careful, which can slow things down a lot - I'd be tempted to keep them as files in a suitable HDD and store the path to the image in the DB instead. That also makes it easier to do regular (non SQL) backups, as you don't need to copy a single multi-terabyte file...
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

There are a lot of discussions regarding whether storing BLOB Data in the Database or in file system. You can check the links below, learn the advantages/disadvantages and see which way works better for you.

http://forums.asp.net/t/1096999.aspx[^]
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 23 Dec 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100