Link Details

Link 1174441 thumbnail
User 319615 avatar

By brianjlowry
Published: Jul 02 2014 / 18:01

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.
  • 6
  • 0
  • 341
  • 812

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.

Voters For This Link (6)

Voters Against This Link (0)

    Java Performance Optimization
    Written by: Pierre-Hugues Charbonneau
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java EE7
    5. HTML5 Mobile
    1. Node.js
    2. Debugging JavaScript
    3. OO JS
    4. JSON
    5. Ajax