Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 storing binary files in sqlserver over windows

Author  Topic 

benoityip
Starting Member

14 Posts

Posted - 2003-09-19 : 01:11:30
What are the reasons to convince myself to store the binary files, such as word docoument in sql server than on windows?

I have got over 1 million documents to store. Is there any degrade in performance?

Ben

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-09-19 : 01:22:22
Store documents on file server, document location in db server.
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-09-19 : 02:53:41
Pretty much everyone here will tell you to store the files in windows, not in SQL server. Only store the paths of the files in SQL server.

One million documents?? Damn!!! What kind of storage system are you using for this thing??

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -