Post reply

Holding large number of Images in Sql Server or Holding then in File System

  • August 16, 2011 at 3:54 am

    #242151

    I have about 100,000,000 images (each one's size less than 10K , averagely 6K) means about 570GB and at the moment i had stored all of them in SQL Server 2008 R2 in one table.

    My question is that which way has better speed in accessing them ?

    1. Images stay in sql server with a asp.net page or web service for accessing each image with a given image name or id. (maybe using some technics like distributing the sql server on several servers or MS SQL Server parallel data warehouse)

    2. Extracting all images to file system and accessing them via IIS ?

  • August 16, 2011 at 7:22 am

    #1369065

    FILESTREAM would look like a viable solution. Check out the MCM Training videos;

    http://www.sqlskills.com/T_MCMVideos.asp

    New Database Structures in SQL Server 2008

    New Database Structures in SQL Server 2008 - Demo

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply