Subject Re: [IBO] Performance (as a result of blob inserts)
Author Lucas Franzen
"ing. Thijs Kuperus" schrieb:
>
> Hello there,
>
> I keep shooting questions!
>
> Another one:
>
> What is the minimum line speed over which i can reasonably run IBO and
> Interbase on a remote server? Perhaps my situation to illustrate:
>
> I have a server running on the internet. I connect to my ISP with single
> ISDN (64KBit/s). The RTT (Round Trip Time) is between 60 and 200 ms... Now I
> noticed that for instance a blob insert can't go above 4 inserts a sec! Upon
> inspecting the line stats, I saw that for about each 80 bytes a packet is
> send... considering a TCP/IP overhead of about 50 bytes that means a VERY
> bad optimized connection.. on a LAN everything works just great, coz the RTT
> is very low, but when we're on the internet, those small packets really hit
> the performance hard...
>
> So... what do the experts say about this?

It seems that you haven't defined the segment size for your blobs - if
you don't do so then the default sgement size is 80.

You can try to create another segment size and see which performs best.

for example:
create domain T_BLOB_1024 as BLOB SEGMENT SIZE 1024;

Have a look in the Data Definiton Reference, page 71 ff. (DATADEF.PDF
for IB 5.6)

Let me know, if this will improve performance.

Regrads
Luc.