Guido,

While I agree with Paul R's comments that your SP could probably be
optimized.

WRT your issue:

> Therefore I want to force IB to take more RAM, but I don't
> know, how to do so.

The only way to do that, is to increase your DB page size to 8KB (or
16KB if you are using Firebird v1.0), and perhaps increase the number of
DB buffer pages (although 8,196 is ok, beyond 10,000 is generally not
recommended).

Using the larger page size will result in more memory being allocated
(128MB in the case of 16KB pages) but will also result in a
flater/shallower index tree which can result in some performance
increase.


Sean