Not calling CLOSE when fi

To: bmaccion@promus.com who wrote: BM> I'm maintaining some informix C code and have noticed > that there are a lot of places where the programmer didn't > call a CLOSE after he/she was done with the cursor. The > next time the routine is called I assume that Informix > does the close first and then the open as coded, however Yes. BM> Sooo, with say 100 or so extra cursors hanging around open > is there any performance to be gained by closing them? NO! I went on an Informix Optimisation course, and we were clearly told that CLOSE then OPEN is actually slower than OPEN implying the CLOSE. Of course, that was a while ago, ... Regards, billy.wheeler@digitec.co.za --- . SPEED 1.40 [NR] . . <-- Grain of Salt. Take as needed with above advice ---- Digitec Online - 20 Nodes * Johannesburg, South Africa +27-11-476-2008 * Best BBS * Best Sysop * @digitec.co.za * RsaNET User Choice Awards 1993 *