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


--
Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa
http://www.synectics.co.za
mailto:vince@...