Am 28.05.2014 11:38, schrieb Mike Ro miker...@gmail.com [firebird-support]: > > > I am sorry to bump this, but has anyone else got experience of using > blobs on Linux?
Yes, of course, but I never felt the need to time the operations, we are using a udf s.th. like: void EXPORT fn_b_load ( char* s , BLOB b ) { unsigned char *buffer; if ( b->blob_handle ) { int buffsize = 4096; FILE *file; unsigned char *fname = intern_recode(s); file= fopen ( fname, "rb" ); if ( file ) { buffer= ( unsigned char * ) malloc ( buffsize ); if ( buffer ) { int readSize; for ( ;; ) { readSize = fread ( buffer,1,buffsize, file ); ( *b->blob_put_segment ) ( b->blob_handle, buffer,readSize ); if ( readSize != buffsize ) break; } free ( buffer ); } fclose ( file ); } free( fname); } } to load documents into the database. I will try to find the time to check thiswith some big mp3's. fsg -- "Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets." - J.K. Rowling