Home > Archive > MS SQL Server > October 2006 > drawbacks of Saving documents to Sql server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author drawbacks of Saving documents to Sql server
sameer

2006-10-24, 6:38 pm

Hi all,

..Net 1.1
Sql server 2000

i am working on a document managment module of my application, all i want to
do here is save the documents uplaoded by the user from my winforms over
webservices application\ webforms applicatoin to sql server 2000. I have been
told saving it on the webserver's file system might be a better way but seems
that microsft is gong more towars saving everthing in sql server. So my
question to the gurus out there is

1. does any one really have any hands on experience saving documents to sql
server 2000 and if so please tell me if u have any kind of performance issues
with this.

2. i was told that sql server is kind of a little slow in streaming out the
documents from the database, expecially bigger ones when compared to the
retriving it from the web server's file system, is this true ?

3. please tell me any other problesm that u might have faced when saving\
retriving files from the database.

4. is sql server 2005 any better in saving and retriving documents from the
database.

thanks

sameer

Scott Morris

2006-10-24, 6:38 pm

Answered in .programming.

Please do not post the same message independently to multiple newsgroups.


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com