Subject | RE: [firebird-support] Windows vs linux server performance |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2006-01-25T05:11:24Z |
On 24 Jan 2006 at 16:47, David SuŠ±rez wrote:
Try 2000.
Usually applications don't use segment size anywhere but isql may
respect it and receiving BLOB byte-by-byte may be the source of
slowness.
--
SY, Dimitry Sibiryakov.
>Anyway, looks like page size is not affecting the result too much:Try to set bigger segment size for your BLOB. 1 byte is too small.
>backing up and restoring same database to 1024 and 16384 page sizes
>gives similar times for the test.
Try 2000.
Usually applications don't use segment size anywhere but isql may
respect it and receiving BLOB byte-by-byte may be the source of
slowness.
--
SY, Dimitry Sibiryakov.