On Thu, Jun 27, 2002 at 07:28:09AM -0400, Jeff Urlwin wrote:
> Martin,
>
> Actually, most times it's MUCH faster to store the file name in the database
> and have the "application" retreive it from there. In my experimentation
> (admittedly a long time ago), it was an order of magnitude faster to store
> the images on the file system. I have not, however tested the BFILE type.
> The "relatively new" BFILE type in Oracle stores the file in the file
> system, but you can retrieve the contents via SQL. That may be faster than
> the old store it in a long method. However, storing it in the file system
> and having the application retreive the data from the file system used to be
> orders of magnitude faster. SQL*Net may have gotten faster, but the raw
> file system is probably still faster...
True.
DBD::Oracle (and/or/via Oracle::OCI) could provide hooks into OCI
streaming for LOBS that would make it rather faster than it is now.
Something like
$h->{ora_lob_stream} = sub { print $_[0] };
and the sub would be called *by oracle* as lumps of new data stream
in from the server.
Patches (or cheques :) welcome.
Tim.
