audio storage

• mjschwenger

  SSCarpal Tunnel

  Points: 4019

  More actions

  December 29, 2003 at 1:19 pm

  #101828

  Hi, I have currently about 245GB of audio files stored on 3 storage servers. We are thinking of consolidation of these files on a single storage. Currently the retriving is done by the VFP program and it's quite slow, even opening the folder in Windows Explorer takes time. What if these files are stored in a SQL DB as BOL and the program pulls them from there? Do you think the process will speed up if SQL storage is used?

  Any input is greatly appreciated.

  Thanks,

  MJ

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 29, 2003 at 1:30 pm

  #488057

  http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

  If the files are used for streaming performance, I don't think SQL Server is a good choice compared to the file system.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]