We are building a asp.net application in VS2010 and .Net4 environment. One of the critical requirement is performance. In most of my screen, there are few dropdown and Menus which are common and they are retrived from database (Oracle). The value in the dropdown or the menu does not change very often. We are thinking of caching the values so that it will be faster.
We are thinking of using Sql Server CE4 to store the cache. I read through the below article of Scott and he says that SQL Server CE4 supports asp.net application.
COuld you please suggest if this is a good approach. I want to avoid storing XML files in the web server as reading and writting XML from disk involves IO operation which is a costlier operation. There is another option of storing data in application cache. But number of users are large as well as the caching data is likely to grow. So storing in application chace may have an impact on the web server's memory. So I am thinking of using SQL Server CE4.
View Complete Post