Re: Not calling CLOSE when finished.

Posted in 1994

Ron Delpiere-Smith — 4 May 94 14:50:32 GMT — source: Informix-list mailing list archive (1991-1998)

ben@syd.au.swissbank.com (Ben Kelley (good guy)) writes: >Informix also told us that we should FREE the cursor after closing >it. I'm not sure how this, or the CLOSEing (or not) of cursors >affects performance. Any ideas anyone? > - Ben Kelley Ben, When a curasor is declared the amount of memory that you sqlturbo uses will grow. This memory alloaction is still in use even after a CLOSE statement. The FREE statement will deallocate this memory making it available for another part of you application to use. Ron Delpiere-Smith reds@informix.com