Orchard SQL Session State
Orchard SQL Session State
Working with Orchard on a WinHost shared server and having access to only 100mb of memory on my basic account, my Orchard application was exceeding the amount of memory usage in initial page load, and the server was flushing or refreshing the memory, and I was getting half of the page on the bottom a session state web.config error. the .css would not load properly. It occurred right when the browsers looked up https:// for my Amazon S3 account, had to go tom 56k dial-up to see that.
After the clearing of memory resources it lost In Proc session state, So WinHost must be aware of this and they will run the session schema on the database you choose for your dedicated Session SQL database for nothing, nice support at WinHost.com.
I have a WinHost Ultimate account Mansbooks.com and Bibwoe.com a DNN site is on so I created a new database of the minimum of 25mb and called it DB_?????_sessiostate, sent a support ticket to the WinHost staff requesting the session schema be ran against Db_?????_sessiostate and very within 20 minutes I received a email from WinHost saying the schema had been installed
After the dedicated session state SQL database has its schema and is online then all you need to do is add one line in your web.config right below system.web with your connection information after the …..data source=YOUR STRING cookie-less=”false”…..
<system.web>
<sessionState allowCustomSqlDatabase="true" sqlCommandTimeout="1800" mode="SQLServer" sqlConnectionString="data source=tcp:s05.winhost.com;database= session
state;user id= sessionstate_user;password=*********" cookieless="false" timeout="60" />
My application took a couple of refreshes before it would load the .css.
I killed the warm up pages cleared the logs, refreshed again and no more session state problems with my Orchard 1.2.41 installation.
