Designing for High Performance

Abstract

This chapter focuses on a few key topics that can help you design high-performance applications that consume data in SQL Database and SQL Server databases. The approach used in this chapter builds a simple but effective WinForms application that consumes data stored both on premises and in the cloud. You’ll 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’ll see how to add multithreading to the shard library using the Task Parallel Library (TPL) and caching using the Enterprise Library (formally known as the caching application block).