Databases Reference
In-Depth Information
Figure 11-15.
Viewing performance metrics in Enzo SQL Baseline
Not
■
if you'd like to see a code sample using the aDo.net provider statistics, go to
Application Design
Last, but certainly not least, design choices can have a significant impact on application response time. Certain coding
techniques can negatively affect performance, such as excessive roundtrips. Although this may not be noticeable
when you're running the application against a local database, it may turn out to be unacceptable when you're running
against SQL Database.
The following coding choices may impact your application's performance:
•
Chatty design.
As previously mentioned, a chatty application uses excessive roundtrips to the
database and creates a significant slowdown. An example of a chatty design includes creating a
programmatic loop that makes a call to a database to execute a SQL statement over and over again.
•
Normalization.
It's widely accepted that although a highly normalized database reduces data
duplication, it also generally decreases performance due to the number of
JOIN
s that must be
included. As a result, excessive normalization can become a performance issue.