1. A method using a graphical user interface (GUI) for tuning access middleware that provides an application with one or more connections to a database, the method comprising: using a computer to perform steps comprising: receiving a first response from a user specifying a type of a driver/provider for the database to be tuned; querying the user, based on the first response received from the user, regarding whether the application connected via the access middleware to the database supports a functionality specified in the query; receiving a second response from the user specifying whether the application connected via the access middleware to the database supports the functionality specified in the query; querying the user, based on the first and second responses, regarding one or more user preferences associated with application performance; receiving a third response from the user specifying one or more user preferences associated with performance; generating, based on the first response received from the user, the second response received from the user specifying whether the application supports the functionality and the third response from the user specifying one or more user preferences associated with performance, a set of connection options and values configured to achieve optimal performance of the driver/provider; and providing the set of connection options and values to the user.
1. A method using a graphical user interface (GUI) for tuning access middleware that provides an application with one or more connections to a database, the method comprising: using a computer to perform steps comprising: receiving a first response from a user specifying a type of a driver/provider for the database to be tuned; querying the user, based on the first response received from the user, regarding whether the application connected via the access middleware to the database supports a functionality specified in the query; receiving a second response from the user specifying whether the application connected via the access middleware to the database supports the functionality specified in the query; querying the user, based on the first and second responses, regarding one or more user preferences associated with application performance; receiving a third response from the user specifying one or more user preferences associated with performance; generating, based on the first response received from the user, the second response received from the user specifying whether the application supports the functionality and the third response from the user specifying one or more user preferences associated with performance, a set of connection options and values configured to achieve optimal performance of the driver/provider; and providing the set of connection options and values to the user. 7. The method of claim 1 , wherein the functionality of the application includes a functionality to use a prepared statement that is compiled for a connection and available to be executed for the connection, the second response includes data describing that the application uses the prepared statement and the set of connection options and values are generated based on the second response including the data describing that the application uses the prepared statement.