Reputation: 4253
Is there a different between session -with mode sqlServer- and Profile ? and who gives us best performance ?
Upvotes: 0
Views: 58
Reputation: 1038720
Of course that there is a difference: SQLServer SessionState mode means that everything you put in the ASP.NET Session (not only user profile data) will get serialized and persisted in a SQL Server database, whereas the Profile could be persisted wherever you configure it to. There are out-of-the-box profile providers that persist the information in SQL Server. Definitely go with a profile. Don't use ASP.NET Sessions at all. The best ASP.NET SessionState mode is the following:
<sessionState mode="Off" />
I'd recommend you to always use it. It will make your web application stateless, the way they should be.
Upvotes: 1