Filtering database schema for better performance in MyEclipse

When you open a database connection in the database browser, the default action is to get information about each database schema. Database Explorer allows you to manage these patterns through a database connection selection filter, and the main reason for applying pattern filters is optimization. In this tutorial, you will learn to:

• Filter Database Schema

Duration: 10 minutes

No myeclipse? Download Now

Filtering the database schema has the following advantages:

• Improve connection performance when opening a database connection
• Limit the amount of information that the database browser renders
• Added metadata retrieval performance to support SQL code completion features

Pattern filters are created as part of a connection profile definition and are managed using the Connection Profile Wizard. Create a pattern filter to do the following:

1. In the database browser, right-click the connection and select Edit.

2. Click Next to continue with the schema Details, which, by default, shows that all mode options are selected.

3. Select the show selected mode option and the initial mode list is empty.

4. Click Add to view a complete list of available database connection modes.

Note : The add operation attempts to connect to the database and retrieve all the schema lists.

Mode details

5. From the full list of database schemas, select the connection you want to manage the mode, and then click OK.

Select Mode Management

The list of selected modes is updated.

Mode filter Connection Configuration file

6. Click Finish to close and reopen the profile, and to filter all connections in the active mode.

Enable Database connections for filters

MyEclipse official Chinese online line, welcome to download Communication!

Filtering database schema for better performance in MyEclipse