Databases Reference
In-Depth Information
Typically, you notice a negative impact in the scalability of your application when
a bottleneck is present. If only one or two users access an application, you may
not see a negative effect on throughput and response time.
Table 10-2 Good Coding Practices and the Hardware Resources
They Impact
Good Coding Practice
Memory/Disk
CPU
Network Adapter
Reduce network round trips
✓
✓
✓
Don't keep more connections and
✓
prepared statements open than needed
Don't leave transactions active too long
✓
Avoid using auto-commit mode for
transactions
✓
Avoid returning large amounts of data
✓
✓
from the database server
Avoid using scrollable cursors unless the
✓
✓
database fully supports them
Maximize query plan reuse
✓
Minimize data conversions
✓
Earlier in this topic, we provided detailed information about database drivers
and how they can impact performance. To recap, a database driver can degrade
the performance of your database application for the following two reasons:
•
The driver is not tunable. It does not have runtime performance tuning
options that allow you to configure the driver for optimal performance.
•
The architecture of the driver is not optimal.
In general, even when two database drivers implement all the same function-
ality, their performance may be quite different when used with your database
applications. If you are experiencing less than optimal performance with the
database driver you are using, consider evaluating another database driver.
