Subject Re: [firebird-support] Writing to BLOB
Author Ivan Prenosil
> I'm trying to store files into database and it works. But I have
> problem that it is too slow (read 300kb/s, write 170kb/s). I tried to
> use larger segment of BLOB (80b vs 4096b) but only speed for reading
> raise to 316kb/s. It is possible to have it faster? I'm using C API
> and reading/writing to blob using isc_get_segment/isc_put_segment. Do
> u have any pointers? I believe that on my computer it should be faster
> (exactly much more faster :) P4 3GHz/2GB RAM)

To increase speed of writing blobs, you can preallocate some
space for database file (i.e. increase its size).
E.g. create table, fill it with lot of rows using SP, then drop the table.
Database file will remain larger and inserting new data will be faster.

Ivan
http://www.volny.cz/iprenosil/interbase/