Home » Other » General » Storing images and movies in BLOB (Oracle 9)
Storing images and movies in BLOB [message #350002] Tue, 23 September 2008 13:42 Go to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi @ all,
i just want to know if it is useful to store a lot of images an movies in an oracle database using blobs. Are there any performance issues that i have to expect? The amount of data is approx. 20Gb. An seperate tablespace for thie image table would be used.

Do you have any other suggestions for storing images and movies?

What do you think about this?

Thanks for every reply.

Regards
eigeneachse

[Updated on: Tue, 23 September 2008 13:43]

Report message to a moderator

Re: Storing images and movies in BLOB [message #350017 is a reply to message #350002] Tue, 23 September 2008 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i just want to know if it is useful to store a lot of images an movies in an oracle database using blobs.

If you need it.

Quote:
Are there any performance issues that i have to expect?

Compare to what?

Quote:
Do you have any other suggestions for storing images and movies?

Read Application Developer's Guide - Large Objects

Regards
Michel
Re: Storing images and movies in BLOB [message #350023 is a reply to message #350017] Tue, 23 September 2008 15:14 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Michel Cadot wrote on Tue, 23 September 2008 21:46


Quote:
Are there any performance issues that i have to expect?

Compare to what?


This was meant in general. I thought about IO issues or something like this.

Thank you very much for the Link. I will take a look at this.

regards
eigeneachse
Re: Storing images and movies in BLOB [message #350088 is a reply to message #350023] Wed, 24 September 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at these sections from previous release:
Why Use LOB?
Frequently Asked Questions about LOBs

Regards
Michel


Re: Storing images and movies in BLOB [message #350317 is a reply to message #350002] Wed, 24 September 2008 13:27 Go to previous message
eigeneachse
Messages: 37
Registered: July 2008
Member
Thank you Michel for the Links. Smile

Regards
eigeneachse
Previous Topic: Estimating Database based projects
Next Topic: Virtualization Pricing trends
Goto Forum:
  


Current Time: Tue Dec 06 06:07:30 CST 2016

Total time taken to generate the page: 0.07410 seconds