DB Session state was designed for SQL Server...a high performance database engine, one of the fastest and most stable on the market. You are using it with a free download that some 16 year olds knocked up in their bedroom.
There is a third option that might work for you which is StateServer. This is the same concept as what you are doing, in that session is held on a remote machine, however it is held in-memory in a service rather than in a database.
All-Star
37441 Points
9076 Posts
Re: Session state using MySQL
Feb 06, 2013 04:58 AM|AidyF|LINK
DB Session state was designed for SQL Server...a high performance database engine, one of the fastest and most stable on the market. You are using it with a free download that some 16 year olds knocked up in their bedroom.
There is a third option that might work for you which is StateServer. This is the same concept as what you are doing, in that session is held on a remote machine, however it is held in-memory in a service rather than in a database.
http://msdn.microsoft.com/en-us/library/ms178586(v=vs.100).aspx