 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / October 2005out of process session state - how much slower?
Hi peeps I'm having some problems with my Session State sticking (it keeps resetting itself) - I haven't looked into it yet, but I was wondering about using SQL Server as an out of process state manager? I've heard it's slower - and I was just wondering... how much slower? (this is for an Intranet app) Cheers Dan We actually roll our own session state, but we have an option to keep it in sql server. I have to say, I have not noticed a performance difference, nor have heard of anyone else who has. To see how much slower it would be, I would say, try it out. Do some performance benchmarks with the 2 different types of session state. > Hi peeps > [quoted text clipped - 11 lines] > > Dan If my memory serves me correctly (and someone please correct me if I'm wrong) but: StateServer ~ 10 % loss SqlServer ~ 20% loss > Hi peeps > [quoted text clipped - 11 lines] > > Dan The key is : 10-20% of *what* ? If it's 10-20% of a few milliseconds, does it impact performance all that much ? A key element will be network lag. If there's packet latency in your network, and your State Server or your SQL Server are downline from your web server, that will have considerably more impact on performance than the almost negligible performance impact of having State Server or SQL server maintain state, instead of maintaining state with Inproc. Also, if you absolutely need to maintain state out-of-process, then whatever performance cut is taken will be worth it. Juan T. Llibre, ASP.NET MVP ASP.NET FAQ : http://asp.net.do/faq/ Foros de ASP.NET en Español : http://asp.net.do/foros/ ====================================== > If my memory serves me correctly (and someone please correct me if I'm wrong) but: > [quoted text clipped - 13 lines] >> >> Dan > Hi peeps > [quoted text clipped - 4 lines] > I've heard it's slower - and I was just wondering... how much slower? > (this is for an Intranet app) I would always refer to Pat Ng's Session FAQ. http://forums.asp.net/7504/ShowPost.aspx  SignatureJim Cheshire JIMCO Software http://www.jimcosoftware.com Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.