performance of inserting large objects
Posted in 2003
Hi,
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
NETTYPE soctcp,1,50,NETsqlhosts uses onsoctcp
Can anybody suggest me how to improve the performance ?