I have implemented a memory database type using shared lists and Linq, and it is consumed by an ASP.NET application. Building this database in memory takes about 45 seconds (it is built from the database), so we are trying to minimize the ASP.NET application pool for reuse once a day at 1:00, to avoid reloading the workflow in the middle of the day and rotating in for 45 seconds, restoring the database.
I would like to move our database to another process, isolated from the ASP.NET workflow, but I'm not sure how I can get the objects in the ASP.NET application to talk to a separate process that will run the database. Should I use TCP listener type? I know that IIS was able to host libraries and make them accessible using remote access ... is this still possible?
If you are wondering why I ran into the whole memory database problem because it launches the application with faceted search. The use of Linq and memory lists is much faster than in the database for each search.
Thanks in advance for any advice.
source
share