Controlling Cursors (Was OPEN_CURSORS is getting out of hand!)
Date: Tue, 6 Dec 1994 17:43:19 GMT
Message-ID: <James.Lawrence.47.0011B956_at_epamail.epa.gov>
In article <stanbD045Iz.9G3_at_netcom.com> stanb_at_netcom.com (Stan Brown) writes:
> Hmm, I just started runing inot this and I just recompiled the
>offending ProC program using HOLD_CURSORS=no. Is this a new bug ?
> What version are you rinning ? What platform ?
>--
>Stan Brown stanb_at_netcom.com 404-996-6955
>Factory Automation Systems
>Atlanta Ga.
>--
>DOS ... is still a real mode only non-reentrant interrupt
>handler, and always will be. -Russell Williams
If you really want to do this correctly then you should use hold_cursor and release_cursor selectively inline to close those cursors in your program that will be executed once or infrequently to save memory. Then use them again to keep open frequently executed statements to improve performance. This will maximize performance and minimize wasted memory.
Lawrence Received on Tue Dec 06 1994 - 18:43:19 CET