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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 26 Oct 2012 21:37:44 +0000 (UTC)
Message-ID: <pan.2012.10.26.21.37.44_at_gmail.com>

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?

-- 
Mladen Gogala
http://mgogala.freehostia.com

Received on Fri Oct 26 2012 - 23:37:44 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Inserting BLOBs from files with the filename stored in another column"
Previous message: Mladen Gogala: "Re: Inserting BLOBs from files with the filename stored in another column"
Maybe in reply to: leichtenfels_at_gmail.com: "Inserting BLOBs from files with the filename stored in another column"
Next in thread: Gerard H. Pille: "Re: Inserting BLOBs from files with the filename stored in another column"
Reply: Gerard H. Pille: "Re: Inserting BLOBs from files with the filename stored in another column"
Reply: leichtenfels_at_gmail.com: "Re: Inserting BLOBs from files with the filename stored in another column"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message