allow user to specify initial schema selection

Description

currently the reveng asks the database for all tables and then we filter them via table-filter's.

This works fine, but have a big performance penalty for large db's; we should add a way for the user to specify which schema(s) we should lookup .

Environment

None

Activity

Show:

Max Rydahl Andersen March 5, 2006 at 9:18 AM

updated in svn so it is match-* instead to align with the other attributes that has .* behavior.

e.g.
<schema-selection match-catalog="PUBLIC." match-schema="OVRTEST" match-table="."/>

Max Rydahl Andersen March 3, 2006 at 12:51 PM

added first version to svn:

<!-- a empty one is valid and means select everything without considering schema/catalog/table (the default in none specified at all)-->
<schema-selection/>

<!-- Only for something matching in schema OVRTEST -->
<schema-selection schema="OVRTEST"/>

<!-- Only for something matching in catalog UBERCATALOG and schema OVRTEST -->
<schema-selection catalog="UBERCATALOG" schema="OVRTEST"/>

<!-- .* is valid, will be translated into % -->
<schema-selection catalog="PUBLIC." schema="OVRTEST" table="."/>

Fixed

Details

Assignee

Reporter

Participants

Max Rydahl Andersen

Components

Fix versions

Affects versions

Priority

Created March 3, 2006 at 12:49 PM
Updated March 5, 2006 at 9:18 AM
Resolved March 3, 2006 at 12:51 PM