Re: Inserting BLOBs from files with the filename stored in another column

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 28 Oct 2012 20:34:09 +0100
Message-ID: <508d88b1$0$3105$ba620e4c_at_news.skynet.be>



Mladen Gogala wrote:
> On Fri, 26 Oct 2012 03:32:14 -0700, leichtenfels wrote:
>
>>
>> I don't know, if this is good style, but it seems to work.
>> Sorry for the trouble, regards,
>> Leo
>
> I am currently on the client site and cannot compare the speed. I will try
> pitting your script against a Perl script the next weekend. My bet is on
> the Perl script.
> I will use RDBMS 11.2.0.3.4, the latest and the greatest. For a comparison
> to make sense, I have to ask what version of the database are you using
> and how is the LOB segment created? I am interested in CACHE/NOCACHE
> attributes. Also, are you using flashback DB?
>
>
>

He might very well beat the php if he added a freetemporary, otherwise his routine might slow down and run out of memory. Received on Sun Oct 28 2012 - 20:34:09 CET

Original text of this message