RE: Storing Images

From: pmattson (pmattson_at_discussions.microsoft.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 12:59:02 -0700

One drawback that I know of: These large images may use a lot of your SQL
server's data cache (if they are accessed frequently) potentially leading to
slower performance accessing other non-image data in your SQL server. If your
enterprise scanning module includes a lot of other non-image data and you're
limited in the amount of hardware resources for your SQL server (mainly RAM),
then you may want to consider keeping your images outside of the SQL database
and store links to the files.

I'd say you need to look at:

How many images will you store?
What it the average/median size of these images?
How frequently will they be accessed?
How frequently will they be updated/added?
How capable is your SQL server?
What other data and queries will run on your SQL server?

Good luck!

"Steve Zimmelman" wrote:

> A rather large client would like an enterprise scanning module. I have used SQL
> server to store images in the past (in small tables), but was wondering if there
> are any pitfalls I should know about as the tables grow in size? I expect this
> table will grow into the hundred thousand range quite rapidly. I plan on using
> ADO.
>
> TIA,
>
> -Steve-
>
>
>

Relevant Pages

  • Re: Should I place a Domain controller in each of the 40 stores?
    ... They should be able to do that, one common way is to use a SQL account in an mixed SQL authentication enviroment where the Apps use a dedicated local SQL account to connect to the DB, but again the app may work differently. ... Also note that although it is possible, it's NOT recommended to cluster for example a SQL server that is also a DC. ... We plan to place a SQL server in each store as part of a new POS ... implementation and also migrate to XP Embedded for the POS terminals. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Should I place a Domain controller in each of the 40 stores?
    ... If applicable they could solve the problem, but I was referring to local SQL accounts, not local machine accounts. ... Some apps have an inital Admin that is actually an account that is created during the setup for a particular DB in a SQL server, then that account has permissions to create additional ones with specific security settings through a GUI. ... reduced drastically as the store resources are very static (as compared ... If I were you I would be more concern about SQL replication traffic, not sure how big your AD would be, but with 2003 you've LVR available as long as your Forest Functional Level is at 2003. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Storing Images and Files in SQL2000 with a project DB as front end.
    ... Check the format of the ole objects stored in SQL Server from ... .jpg and other compressed formats. ... When I create SQL Reports I am not able to display the images. ...
    (microsoft.public.access.formscoding)
  • Re: Jebus Keerist Im Not Getting Paid Enough
    ... LEAST he's got to do a Misty shot, ... Convert proprietary images from '92-'06. ... Project Management and SQL dbas with clustering experience. ...
    (alt.2600)
  • Re: Storing Images and Files in SQL2000 with a project DB as front end.
    ... Does anyone have a sample code that I could use to achieve this (using VB ... Bitmaps can be significantly larger than .jpg since they don't have any ... Check the format of the ole objects stored in SQL Server from ... When I create SQL Reports I am not able to display the images. ...
    (microsoft.public.access.formscoding)
Loading