Databases Reference
In-Depth Information
Update 40 Char(20) cols, 40 params,
commit every 128.
20000
15000
10000
5000
0
1
2
3
4
5
6
7
8
9
10
CPU-Bound
Not CPU-Bound
Threads
Figure 4-20
CPU-bound versus non-CPU-bound
Table 4-6
Causes and Solutions of CPU Bottlenecks
Cause
Solution
Insufficient CPU capacity
Add multiple processors or upgrade to a more powerful
processor.
Inefficient database driver
See “Database Drivers,” page 53, for information on why
it's important to choose a good database driver.
Poorly optimized application Analyze and tune your application and database
code or database driver
driver to minimize CPU use. See “Tuning Your Appli-
cation or Database Driver to Minimize CPU Use,” page
114, for more information.
Detecting CPU Bottlenecks
To detect a CPU bottleneck, gather information about your system to answer the
following questions:
•
How much time does the CPU spend executing work?
If the processor is busy
80% or higher for sustained periods, it can be a source of trouble. If you detect
