> yeah. cf 7.. 2-3 times a week minium. > no idea why... With CFMX 6.1 it turned out to be MS-SQL Server Stored Procedures--or rather, the lack of them, that caused the problem.
re-writing the queries as Stored Procs in my CFCs solved a long-standing mystery. My issue, in a nutshell, was that jrun.exe would spin memory use up to about half a gig and then hang. -- will "If my life weren't funny, it would just be true; and that would just be unacceptable." - Carrie Fisher ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:256622 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
