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:
•
•
•
To use the Pervasive Performance Tuning Wizard in Visual Studio:
1
•
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.
•
4
Click Finish to exit the Pervasive Performance Tuning Wizard.