>
> Erik,
>
> I think you could use 16k page size, taking a max of 2GB of RAM.
>
> The option for memory usage on sort operations on firebird.conf could help.
>
> But I could bet that sorting 2 million records will always be slow.
>
> see you !
>

Thanks, I'll give that a try. For some reason I was under the impression
that 8k was the max page size. So far my performance has correlated
almost directly with increasing page size and page cache size, so
doubling the page size should be a good thing!

--erik



[Non-text portions of this message have been removed]