Hi Jan,

--- In firebird-support@yahoogroups.com, Jan Bakuwel
<jan.bakuwel@i...> wrote:

>
> Hi,

...

>
>
> Relevant Firebird parameters in /etc/firebird2/firebird.conf
>
> DefaultDbCachePages = 819200
> SortMemBlockSize = 1073741824
> SortMemUpperLimit = 4294967296
>
> OS: Linux Debian Sarge, kernel 2.6.15.1
> RAM: 8GB
> HD: Hardware RAID5 SATA, 4 discs
>

This parameters will be ignored FB or any 32bit application.
819TonePages are out of range. (<10,000 suitable for <=FB1.x)
1 GB RAM for any allocation to sorting???
4 GB RAM for sorting operations???

Jan, 32 bit executables can addressed only in 32bit range.
FB cannot use this limit totally for sorting only.

if you want high performance, use hardware RAID systems.
in high possibility your SATA RAID system is software based.

First, can you show us your DB design and usege strategy to improve
your performance?

Regards,
Ali