Databases Reference
In-Depth Information
Select 10K rows of 3100 bytes
25000
20000
15000
10000
5000
0
1
2
3
4
5
6
7
8
9
10
Threads
Figure 1-4
Comparing Different JVMs
As you can see in Figure 1-4, the throughput and scalability of the applica-
tion using the JVM represented by the bottom line is dramatically less than the
other two JVMs.
In Chapter 4, we discuss how your environment, both software and hard-
ware (such as the operating system, memory, and CPU), can affect performance.
Another important performance-related component is your database applica-
tion. If your application is not coded efficiently, data requests that your applica-
tion passes along to the database middleware can negatively affect performance.
One common example is transaction management. With most standards-based
applications, the default transaction mode requires the database driver to process
expensive
Commit
operations after every API request. This default auto-commit
mode can impose severe performance constraints on applications.
Consider the following real-world example. ASoft Corporation coded a
standards-based database application and experienced poor performance in test-
ing. Its performance analysis showed that the problem resided in the bulk five
million
Insert
statements sent to the database. With auto-commit mode on, this
