
342
CHAPTER 10 Building ScalaBle applicationS inSharepoint
that additional indexes slow down inserts and updates as the indexes must also be updated
when data changes.
Consider splitting your database into multiple les across multiple drives to increase
throughput. Even a single table can be split across drives using table partitioning, a feature
available in the Enterprise Edition of SQL server.
Is it OK if the outcome isn’t “real time”?
You may want to execute your process in the background or on a schedule and then save the
result for quick access later.
What is the hardware bottleneck your code is bounded by?
There is always a limiting factor in code execution. By determining the resource (or lack
thereof) that is responsible for most of the execution time, you can specically target code or
architectural improvements to reduce the use of that resource or improve the performance of
that resource.
If you answered yes to any of these questions, you have an opportunity to improve the performance
of your code as described. Keep a global view of your code in mind that includes how it physically
operates within the computing resources available, with an eye out for how those resources could be
more effectively used.
SUMMARY
Performance and scalability are wide-ranging topics that are encompassed in the entirety of process-
ing on server systems, the networks they run on, and t