By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,974 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,974 IT Pros & Developers. It's quick & easy.

ASP.NET & Sqlserver 2000/2005 Image archiving and presentment

P: n/a
Ron
Hi there

My company is developing a web based document archival and retrieval system,
using ASP.NET, c# and sqlserver 2000. This development is in testing at
present and all looks promising.

Here's some background to the app...

Our application stores the document in an image field along with other
information related to the document that we index and use to search and
locate it.
We are doing this using an ASP.NET web page. Currently this all works and
performs well; we read the document from the db image field (into a c#
bytearray) and then response.write this back to the user.

My question is related to the storing of '.pdf' documents in sqlserver image
fields.

I have read in at least one place that we should actually have the documents
kept on the filesystem instead of the image field, and just hold a string
'path' to the documents location in the filesystem, ie C:/docs/mydoc.pdf.
This is to increase peformance.

I expect our system to be used by several hundred users at some point and
would like to sleep well at night knowing i have made the right choice. It
would be a shame to change direction at this late stage, so some opinion or
guidance would be very much appreciated. Are we doing things all wrong? If
not can you give any tips on how to make sure the streaming of data from
sqlserver to iis is quick?

Ps, we have sqlserver 2005 available now, if this makes any differnce to the
answer.

Thanks and look forward to a reply from my first ever post as a msdn
subscriber....

Feb 5 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.