Linq to SQL and Realtime Data
Posted
by Jeremy
on Stack Overflow
See other posts from Stack Overflow
or by Jeremy
Published on 2010-06-05T08:17:12Z
Indexed on
2010/06/05
8:22 UTC
Read the original article
Hit count: 200
I have an application that needs to constantly (every 50ms), call to an MVC action, and pickup/drop off data.
I am using Linq to SQL and MVC because of how simple they are to implement, and I know that they aren't perfect when it comes to performance, but it works relatively well, but the best speed I can get with my current approach is 200ms (without requests overlapping).
Each call to the site will create a new instance of the datacontext, query/insert it and return that data.
Is there a way to have the datacontext static, but submitchanges say every 5 seconds, so that i am pretty much hitting an in-memory version of the data?
© Stack Overflow or respective owner