>> If I run the sub proc to get the balance one by one though, it runs at
>> 1-2 seconds. So, using IBExpert, I manually worked my way through the
>> list, and on the 5th account - 22 seconds to execute. I try the very
>> same account again, and it takes 1 seconds. I need to carry on down
>> the list and do a few more, before I can get it to go slow again.
>>
>> Any ideas what to try?


>Get the statistics on the various runs of the sub-procedure- reads, writes, fetches, and marks.
> There may be other statistics available now describing your cache hit rate. You should also check the depth of indexes (gstat).
> Which type of garbage collection are you using separate thread,
> cooperative, or blended? How many tables and indexes are you touching in
>computing an account balance?

Thanks, Ann!

I'll poke around in IBExpert, and the monitoring tables and see if I can figure out how to do all this - it'll be a learning curve for me ;-)