Yes, you're right. Just making sure that whoever read this knew it was an explored avenue ;)
The issue with the driver is documented: http://www.alagad.com/blog/post.cfm/mssql-driver-issue-with-cf-8-0-1 Using either the MS or the jTDS driver eliminates the issue. Dominic On 2 February 2010 15:15, Leigh <[email protected]> wrote: > > > heap memory usage is dropping > > from an average 800-1000 Mb with the CF shipped driver to > > around 300Mb with > > the jTDS driver. Youch. > > Very interesting. If it is really not arbitrary, I wonder what causes such > a significant difference. I will have to do some more reading on jTDS. > > > Quite, and using semi-colons did not help in this case. > > I could be wrong, but I think comment about semi-colons was > just about standards / best practices , rather than having any > impact on this case. MS SQL may be a bit unusual in not > requiring them for multiple statements. > > -Leigh > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
