Ben nadel wrote: > This is very interesting. I have never really learned very much about > CURSORS but they seem quite cool. I didn't realize that you could make > any SQL objects that would live past more than one CFQuery tag.
You have to put it in a transaction to make sure you keep using the same connection, but you can also persist temp tables, savepoints and probably a few more. > I will > definitely give this a try for experimentation sake. CURSORS do seem > like something that are very useful... Are there any downsides to > CURSORS that I should know about right off the bat? They consume resources on the DB server so be careful with keeping many big ones open. Try to use flags like NO SCROLL and FOR READ ONLY to minimize their performance impact. And on MS SQL Server 2005 you might want to look into snapshot isolation (which already is the default for Oracle, PostgreSQL, InnoDb etc.). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
