Hi,

I am new to sql server and especially using blobs.
In my application, I am dealing with some microsoft word documents. I feel that I can store them sql server as text/image column as its more secure to save them in database versus saving them on the file system.
Are there some issues involved in doing so. Some performance hits etc.
Pls guide or send some such links describing the same.

Thanks in anticipation
Sandeep

If you set up your security properly both storing it in the file system and the SQL server can be equally secure. Security on the file system would be controled by NT groups... the SQL could use a "spin your own" security.

The analysis of which would be better for you to use would depend on your requirements and what your storing and how secure is secure enough... Types of hardware availible.. speed and size of drives.. location of SQL server. Location of the DB on the drives...

Your going to need to think about all of that to know which solution will be better for you.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Thx for putting points to my notice.
I would like to know, are there some issues with using blobs in sql server as I saw at a few places that it make database heavy and all blob related operations are heavy resulting in performance drop.

Is it tough to store and manipulate data in text/image columns?

Regards / sandeep

Hi,

Thanks for putting the mentioned points to my notice which I shall surely keep in mind.
May I know whether there are any performance hit in storing and manipulating data using blobs ie text/image columns in sql server.
Also, will it be really complex/tough to store and manipulate document files with usage of blob i.e. text/image columns with respect to using file system.

Thanks in advance.
Sandeep

I answered this already.

The performance hit depends on things like Speed of drives.. location of datastore.. location of data files.. location of physical SQL machine-. Network speed. Network Protocal...

That said- Yes, there will be a hit. How much of a hit depends on all of that information.

I have no idea what kind of manipulation you want to do - so again I can't tell you how dificult it would be.

You might want to try a google search on the topic.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

You can take a look at these posts which were discussed earlier on the same topic, and have better idea.

http://p2p.wrox.com/topic.asp?TOPIC_...=storing,image

http://p2p.wrox.com/topic.asp?TOPIC_...rchTerms=image

You can always search for such topics if any discussed earlier here using the search link

Hope that helps.

Cheers!

-Vijay G