Optimizing the Database

The data tier is the part of a distributed application where information is centralized. That means it’s one of the most difficult parts of a distributed application to scale out because it maintains state. It’s worth squeezing out every extra ounce of performance you can.

Modern database products have come a long way. Microsoft architects confess that, only a few years ago, almost all the leading PC-based relational database management system (RDBMS) products had major limitations with reliability and data integrity. Today these problems have been fixed across the board, and all enterprise-level databases provide a sophisticated set of features for optimizing the speed that queries and updates execute.

Unfortunately, these ...

Get Microsoft® .NET Distributed Applications: Integrating XML Web Services and .NET Remoting now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.