Databases Reference
In-Depth Information
{
// Connection failed
Console.WriteLine(ex.Message);
return;
}
6.
Close the connection.
// Close the connection
Conn.Close();
In a well-tuned environment, 75% to 95% of the time it takes to process a data
request is spent in the database middleware; this includes all the components
that handle the communication between an application and the database man-
agement software. Perhaps the most important component of middleware is the
database driver.
Your database driver can degrade performance if it does not include config-
urable options to tune performance or if its architecture is not optimal. The most
optimal architecture for a driver is database wire protocol, which provides the
following advantages:
•
Elimination of the need for client software installation, configuration, and
maintenance on each computer needing database connectivity
•
Elimination of restrictions of the client software, whether functional or
quality
•
Decrease in latency by eliminating the processing and network traffic
required by the client software
•
Reduction of network bandwidth requirements from extra transmissions
because the driver can control interaction with TCP
Additionally, database drivers that offer runtime performance tuning
options are ideal to use in your database application deployment. Some impor-
tant options to look for are ones that allow you to optimize the driver for the fol-
lowing:
•
Retrieving large objects
•
Reducing network activity
•
Performing bulk operations
