Which option is better saving blob to Db or not

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 2005 Forums

Transact-SQL (2005)

Which option is better saving blob to Db or not

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2007-05-04 : 12:21:49

We are cutrrently saving the files as blob to the tables image cell.

we see the database size growing tremendously.

If we save the uploaded file as a file to the server, will that be efficient, because my question is if the filesize is 50 KB and if i convert it to blob and save to dB will it grow 50KB or more after conversion of file to Blob.

because my application is a document management application so users upload all the document s to the webserver via net.

currently storing as blob under a table.

please share any helpful info. to manage it in a better way.

Thank you very much for the information.

pootle_flump

1064 Posts

Posted - 2007-05-04 : 12:29:06

Hi

The standard thinking on this is files on file system, data in a database. The address of the file is data so just store that. Some differ on this but this is my preference.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-04 : 12:31:35

+1 for that.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

pootle_flump

1064 Posts

Posted - 2007-05-04 : 12:32:36

+1 from me too.

That now makes it 3 - 0

Kristen
Test

22859 Posts

Posted - 2007-05-04 : 12:40:31

+1 here too ... but I reckon that a UserID of cplusplus is going to out-increment all us thread-bound processes!

Some info here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Image,Images

Kristen

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-04 : 13:47:45

+1 here too, lot of doc management apps do this way also.

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 2007-05-06 : 23:08:31

-1 depending on whether the content of the file needs to be subject to the same security model and transactional constraints as the rest of the data.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-05-06 : 23:43:44

need to write ++ or -- instead of +1/-1 when responding to cplusplus!