Re: How do I store big pictures in oracle

I wrote c program to insert/retrieve media data(raw data, image...) using pro*c. Because I am not Form user, and I need a gateway program between web server and oracle.
Althought Oracle DB can support long raw data up to 2GB, but I found it is slow when data size is around several mega bytes. My machine is SGI Indy R4600 64MB. My experience, 10MB raw data will cost me addition 1 min to retrieve (it's not network delay, I can sure this). So, I think that's why oracle made the video server to store digital video data.

You can come http://foursome.hinet.net/lee.html to see a test page and give me your comments.

mamalik_at_cs.wmich.edu:
>Magnus.Eriksson_at_hyd.uu.se wrote:
>>
>> Hello
>>
>> I want to store sattellite scenes, SPOT Landsat etc, in oracle is this
>> possible and if, how do I do it ?
>>
>> best regards
>>
>> Magnus
>
>This is among the FAQs. Oracle supports about 11 mojar types of image formats.
>
>Create a table with long raw field (one long ra column) will store upto
>2 GB of data.
>
>Populate this image field with the help of read_image_file functions in
>ORACLE Foirms 4.5.

-- 
WWW Admin
Foursome Tech. co.
	E-Mail : wwwadm_at_foursome.hinet.net
	Tel : 886-2-532-6868
	Fax : 886-2-532-2070