Also the JDBC-ODBC bridge is not used when talking to SQL server. I'm not sure what the performance difference is between JDBC and ODBC, maybe someone can pitch in here.
Russ > -----Original Message----- > From: Phillip B. Holmes [mailto:[EMAIL PROTECTED] > Sent: Friday, September 29, 2006 1:19 PM > To: CF-Talk > Subject: RE: CF vs. .NET presentations? > > >I imagine it will be the same with ASP. > > DB Session handling in ASP.NET is a native functionality of .NET which you > flip the setting in the web.config file and setup your SQL DB that handles > only those requests...the process and DB hit are incredibly thin and fast. > Remember ADO needs no ODBC bridge (like JDBC). DB hits to MS SQL are going > to naturally be faster. > > --Phil > > > > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Friday, September 29, 2006 11:57 AM > To: CF-Talk > Subject: RE: CF vs. .NET presentations? > > There are a few lines that you can add to CF config files and it will > store > all session data in the db. I tried it and it proved to be a bit slow, > and > I imagine it will be the same with ASP. CF has an arguably better > solution > where it shares the data between all the servers directly, instead of > loading the db server on every request. > > Russ > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
