On 04.06.2014 00:08, Mike Ro miker169@... [firebird-support] wrote:

> Unfortunately I haven't had any success in trying this because
> blob_put_segment() is causing Firebird embedded to throw an instance of
> "Firebird::status_exception" followed by a core dump that I really can't
> get to the bottom of. All the other blob functions work fine (such as
> blob_get_segment) and return correct results.

Ok, this is what I get for a 13MB file on an Intel NUC (Celeron),
database and home are on an USB Drive, so no real good hardware.


SQL> set stat;
SQL> set time;
SQL> select b_loadfromfile('/home/frank/w.mp3') from rdb$database;

B_LOADFROMFILE
=================
0:1
==============================================================================
B_LOADFROMFILE:
BLOB display set to subtype 1. This BLOB: subtype = 0
==============================================================================

Current memory = 37822224
Delta memory = 416616
Max memory = 37899608
Elapsed time= 9.423 sec
Cpu = 0.000 sec
Buffers = 2048
Reads = 0
Writes = 830
Fetches = 1767

I could send you my udf if you want to test it.

Frank