Storing and retrieving image (about 300 MB of each file, which is stored on a remote network directory)

Hot Topic

SELECT permission denied on object
MySQL to SQL Server migration
database owners
Certificate limitations in SQL Server 2005
Debuggin on PDA
Help with SSIS error
Blank Error Messagebox Displayed at startup
Command USE with variable
Unable to link except to SQLClient
SQL Locking up

SQL Server

SSIS: Opening package takes 8 minutes
Report manager problem
Cannot create new SQL database file.
AdventureWorks\AdventureWorksDW question
SQL2005 Query Paging
Broker:Corrupted message
"Slipt" rows based on datetime
Parameter Mapping in an Execute SQL Task
Bitwise operation in SELECT killing performance, *sometimes*?
xml modify 'replace value of' using sql:variable

Storing and retrieving image (about 300 MB of each file, which is stored on a remote network directory)

I have more than 10,000 files in my remote network with a size of 300 MB each file (raster file). My question, what is the right way to store 300 MB file I meant to say how much performance it would be if i store the image file through SQL Server 2005, compared to storing over the remoted network

Any help would be appreciated...

thanks - Benoy




Answer this question

Storing and retrieving image (about 300 MB of each file, which is stored on a remote network directory)

  • Stacy Rothwell

    I would suggest storing the data on a network share, and the appropiate link / reference in SQL Server.

    HTH, Jens Suessmeyer.

  • JohnLR

    Hi!

    Large file in deed.

    Why you need SQL here You will do query, backup, replications, locks, etc Or you need simply storage area

    300MB over network and 300MB in SQL - SQL will be slower, because it still need to pass 300MB over network + own data flow control codes + SQL store data in database, which can use transactions log (which can be large in this case) and data in SQL stored in "pages" which are not 300MB, but few KB, so pages index will be created also.



  • Storing and retrieving image (about 300 MB of each file, which is stored on a remote network directory)
Answer this question