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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.