On 04.06.2014 00:08, Mike Ro miker...@gmail.com [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