My web application is using a SQL Server database that has around 2000 rows. I wanted to know if its better to load all the DB to the RAM (Store it in a static var) and query it using ASP.NET LINQ. I need it only for read operations. I think that the amount of RAM needed is not very high at all. I think it can speed up the application considerably.
I wanted to know if it's a good option, instead of caching the data?
A database that small is already in memory on your server, no need to do it twice.