Unanswered: performance of inserting large objects
I have a performance problem when inserting large objects to IDS.
An insert of 1 MB simple or smart large object takes about 5 seconds while selecting the same amount of data takes 0.1 second. When I use the function FILETOBLOB with "client" parameter, insert takes 5 seconds while when I use "server" parameter on the same file insert takes 0.1 second.
5.0 sec for:
insert into smartblobtable (blobcolumn) values (FILETOBLOB("one_megabyte_file","clinet"));
0.1 sec for:
insert into smartblobtable (blobcolumn) values (FILETOBLOB("one_megabyte_file","server"));
I guess the problem is not in storing data itself but somewhere in the connection. It seems to me that the i/o is somehow optimized for reading not writing.
My system is IDS 9.30 on Linux
sqlhosts uses onsoctcp
Can anybody suggest me how to improve the performance ?