Link Details

In my consulting experience, one of the most frequently overlooked performance issues I see with web applications is the lack of properly-constructed database indexes. Microsoft’s Entity Framework has helped alleviate some of these issues by automatically creating indexes on foreign key constraints – a necessity for domain models with complex object types. While these indexes will speed up queries, most applications are more than likely missing even more important non-clustered indexes for frequently used database calls.

Posted by brianjlowry  |   Jul 02 2014 / 18:01

Add your comment

Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Recommended Links

Written by: Ryan Knight
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Play
  3. Akka
  4. Debugging JavaScript
  5. Design Patterns
  1. Apache Hadoop
  2. REST
  3. Java
  4. Git
  5. Java Performance
Connect with DZone