Chapter 10. Designing for High Performance
This chapter focuses on a few key topics that can help you design high-performance applications that consume data in SQL Azure and SQL Server databases. The approach used in this chapter builds a simple but effective WinForms application that consumes data from both on-premises and cloud data. You first explore a few general concepts and then quickly go into the design and development of a shard library that reads data from multiple databases. Finally you see how to add multithreading to the shard library using the Task Parallel Library (TPL) and caching using the Enterprise Library (formally known as application blocks).
General Performance Concepts
Before diving into the details, let's discuss a few concepts ...
Get Pro SQL Azure 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.