Subject | Re: [IBO] Performance (as a result of blob inserts) |
---|---|
Author | Lucas Franzen |
Post date | 2001-01-24T11:20:27Z |
"ing. Thijs Kuperus" schrieb:
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.
>It seems that you haven't defined the segment size for your blobs - if
> 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?
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.