I concur - for a while we had to do this with Oracle (until newer DataDirect drivers came out) due to connection pooling errors and each DB connection took 200ms. At least CF only made one connection per CF page request, not per query, but it still sucked.
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 14 June 2005 11:11 To: CF-Talk Subject: RE: MS SQL - Cannot Find Stored Procedure > Elaborate please... I'll swear that MM used to recommend this as a > best practice.. I need all the SQL Server performance I can get, If > I'm doing something wrong I'd like to correct it.. To the best of my knowledge, Macromedia has never recommended this. I can see why you might want to do it if you're using FoxPro, but not with MS SQL Server or any other enterprise database server. I don't know how much I can elaborate beyond that, without specific questions, other than to say that creating new database connections unnecessarily is expensive - that's why connection pooling is provided. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
