Subject Re: [ib-support] Memory Useage with Select Procedure
Author Vince Duggan
Geoff Worboys wrote:
> Do you have any idea whether the memory issue that I am seeing is
> normal/expected?

I think Helen hit the nail on the head more or less. IB seems to create these
huge cursors when given unusual select statements.

> Looks like I have lots more testing to do. I may have to stop being
> lazy and writing stuff in stored procedures, and revert to client
> based processing (even if I have the client app sit on the server to
> reduce network overheads).

I disagree. Use lots of stored procedures. The way to faster apps is to keep
Select statements simple.


Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa