Using the Pervasive Performance Tuning Wizard
The Pervasive Performance Tuning Wizard leads you step-by-step through a series of questions about your application. Based on your answers, the Wizard provides the optimal settings for performance-related connection string options for your Pervasive PSQL data provider.
When you launch the Pervasive Performance Tuning Wizard from Visual Studio, you can:
•
Generate the values for connection string options that are related to performance. These values can be copied into a connection string.
•
Modify an existing connection.
•
Generate a new application pre-configured with a connection string optimized for your environment. The Performance Tuning Wizard provides options to select the type of application and the version of ADO.NET code that you want to use.
To use the Pervasive Performance Tuning Wizard in Visual Studio:
1
Do one of the following steps to start the Performance Tuning Wizard:
•
To create a new connection, select Tools / Pervasive / Run Pervasive Performance Tuning Wizard.... When the Performance Tuning Wizard Welcome dialog appears, click Next. Continue at Step 2.
•
To modify an existing connection, in Server Explorer, right-click a data connection, and then select Run Pervasive Performance Tuning Wizard.... When the Performance Tuning Wizard Welcome dialog appears, click Next. Continue at Step 2.
2
The Wizard presents a series of questions about your environment. Click Next to proceed through the Wizard. Figure 5 shows an example of one of the questions you may be asked.
Figure 5 Pervasive Performance Tuning Wizard
3
When you have answered all questions for a data provider, the Result dialog appears, and a connection string is displayed. Figure 6 shows the connection string options related to performance that the Pervasive Performance Tuning Wizard generated.
Figure 6 Pervasive Performance Tuning Wizard Result Dialog
 
Select one of the following actions:
•
To make the connection string available to other applications (the initial default), select Copy the connection string to clipboard. You can use the connection string in other applications.
•
To create a new connection, select Create a new connection with the Performance Tuning Wizard connection string options.
The Modify Connection dialog box appears, allowing you to specify a host, password, user ID, and other information.
•
If you launched the Performance Tuning Wizard from an existing connection, select Re-configure the connection with the additional Performance Tuning Wizard connection string options.
•
To create a new application, select Generate a new application pre-configured with these connection settings. In this example, a Pervasive application is generated, using the Pervasive Project template. See Creating a New Project for more information about the provider-specific templates.
Define additional information for the new application:
•
Select Using ADO.NET 1.0 provider-specific interfaces to create an application compatible with the ADO.NET 1.x specification.
•
Select Using ADO.NET 2.0 common programming interfaces to create an application that uses the ADO.NET common programming model.
•
Type the location for the project, or, click Browse... to select the location.
•
Select the project type. By default, the Wizard creates a C# application.
4
Click Finish to exit the Pervasive Performance Tuning Wizard.