SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Which option is better saving blob to Db or not
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cplusplus
Aged Yak Warrior

534 Posts

Posted - 05/04/2007 :  12:21:49  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 05/04/2007 :  12:29:06  Show Profile  Reply with Quote
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.
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 05/04/2007 :  12:31:35  Show Profile  Visit spirit1's Homepage  Reply with Quote
+1 for that.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 05/04/2007 :  12:32:36  Show Profile  Reply with Quote
+1 from me too.

That now makes it 3 - 0
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 05/04/2007 :  12:40:31  Show Profile  Reply with Quote
+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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 05/04/2007 :  13:47:45  Show Profile  Reply with Quote
+1 here too, lot of doc management apps do this way also.
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 05/06/2007 :  23:08:31  Show Profile  Reply with Quote
-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.
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 05/06/2007 :  23:43:44  Show Profile  Visit jezemine's Homepage  Reply with Quote
need to write ++ or -- instead of +1/-1 when responding to cplusplus!




www.elsasoft.org
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 05/07/2007 :  05:37:03  Show Profile  Reply with Quote
+1 to LoztInSpace ... or is that -1?!
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 05/07/2007 :  08:20:23  Show Profile  Reply with Quote
quote:
Originally posted by Kristen

+1 here too ...

quote:
Originally posted by Kristen

+1 to LoztInSpace ... or is that -1?!

Does that make your sum contribution 0?

Edited by - pootle_flump on 05/07/2007 08:21:27
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 05/07/2007 :  08:42:25  Show Profile  Reply with Quote
Same as usual then!
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 05/07/2007 :  10:13:08  Show Profile  Visit jezemine's Homepage  Reply with Quote
so this then?

++Kristen--


www.elsasoft.org
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 05/07/2007 :  12:22:24  Show Profile  Reply with Quote
Now Optimised:

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000