6. The method of claim 1 comprising: configuring the driver/provider with the generated set of connection options and values.
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 a functionality of the application, the functionality of the application including a functionality to use a prepared statement that is compiled for a connection and available to be executed for the connection, wherein the prepared statement is compiled once for the connection and available to be executed two or more times for the connection; receiving a second response from the user specifying the functionality of the application, the second response including data describing that the application uses the prepared statement; generating, based on the first response received from the user and the second response including the data describing that the application uses the prepared statement, 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.