Hi everyone! IÃÂ´m trying to find a way to store some sql data on the server (memory?) in order to save many connectios to the database that will almost everytime return the same. I'm thinking (if possible) a way that the server (every XXX seconds, minutes, hours) refresh itÃÂ´s memory data from the database. So every new query from a client is populated with the data in memory instead of the database. Hope i wrote it in the right place and somebody could help me. Thanks in advance.
PD: Im working in asp.net 4 w/ visual studio 2010 and sql server 2008.
View Complete Post