I am building a small web application that need to handle 1000 requests per minute.
Each request needs to write one simple row to the database.
I am doing second level cache for the reading.
Can I do session per request in this case? Should I reuse the session? What is the best practice for this kind of situation?
It will be written in C#, SQL SERVER 2008, ASP.NET Generic Handler.
Thanks
Session per request should be fine, but you will definitely have to do load testing, as there is no way to predict if your setup will handle the load, or what the bottlenecks will be.