Subject | Re: [Firebird-Java] Re: Test results: JayBird vs Interclient on blob select on Linux and Windows |
---|---|
Author | Sergei P. Volin |
Post date | 2003-03-04T13:28:16Z |
Hi,
results
were with receive/send buffer size again at 8192. Does anybody know why?
2. Another my mistake - on other values of buffers size results are slower
not in 3 times but in 30 times approximately. This is big difference. I'm
sorry for
misprint.
Thanks,
Sergei Volin.
> No, Roman - it is not related either to kernel nor to jvm at all. But Ithink
> I know to what parameter it is really related. Why don't you think thatthis is a
> page size of db. When the buffer size equals to db page size there is noneed
> to wast time or resources on synchronization of data transmition. Whenthey are
> not equal everything immedeately is slowing down. E.g my db page size is8kb.
> And the best result - about 6sec - was obtained at value of 8*1024 ofbuffers sizes.
> Other values - 16, 32, 64 *1024 - give the same and worse result about18sec
> , i.e.3 times slower.1. My assumption was wrong - I checked with 16Kb page size - the best
results
were with receive/send buffer size again at 8192. Does anybody know why?
2. Another my mistake - on other values of buffers size results are slower
not in 3 times but in 30 times approximately. This is big difference. I'm
sorry for
misprint.
Thanks,
Sergei Volin.