1. What is the scope of the data context used for these queries? Caching that is keyed by id is done within the scope of the data context: http://blogs.msdn.com/dinesh.kulkarni/archive/2008/07/01/lin...
2. Is the code being run co-located with the database server? If so, this is atypical and these times do not include network overhead.
There are many more questions...
1. What is the scope of the data context used for these queries? Caching that is keyed by id is done within the scope of the data context: http://blogs.msdn.com/dinesh.kulkarni/archive/2008/07/01/lin...
2. Is the code being run co-located with the database server? If so, this is atypical and these times do not include network overhead.
There are many more questions...