Subject Re: Slow first 'Query'
Author Alexander V.Nevsky
Hi Phil. Slow first query certainly is cash filling. I'm not great
inside IB guru, but simple logic - system tables should be as much
cashed as it possible. So I recommend you to take a look at
no matter it is Russian site - SQL is written in SQL. :) As you have
many SP, I suspect play with indexes on RDB$DEPENDENCIES can help you.
And one more - I have not much experience with SS, but for Classic
10000 page buffers is TOOOOOO much - every connection will try to get
such amount of RAM and your OS will start swapping when it will be

Best regards.