Re: Not calling CLOSE when finished.

Posted in 1994

Dennis Pimple — 4 May 94 14:36:18 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? CLOSE frees Database resources (temp tables, etc). A CLOSEd cursor can be OPENed again without DECLARing it again. FREE releases program resources (stack space, etc). A FREEd cursor must be DELCAREd again (call the FUNCTION that DECLAREs the cursor again) before it can be reused. ============================================================ Dennis J. Pimple Informix Software Inc Senior Consultant Denver Colorado USA dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025