]
Barry LaFond resolved TEIIDDES-715.
-----------------------------------
Resolution: Won't Fix
support for JDBC importer is being minimized in favor or Teiid Importer option.
Optimization of the Schema import is via import properties.
Oracle metadata import using Designer takes long time for large
schemas
-----------------------------------------------------------------------
Key: TEIIDDES-715
URL:
https://issues.jboss.org/browse/TEIIDDES-715
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Ramesh Reddy
Fix For: Future
Importing metadata from Oracle database seems to take longer than any other database,
when the underlying the schema is large. This may be because the default settings with
Oracle Driver tries to get lot more metadata then needed. Should explore ways to minimize
the time to take import.
Teiid in the Dynamic VDB import uses "Table Types" and "schema" name
to limit the number of tables it imports, may be we should adopt similar thing in
Designer. It is possible that Designer is already doing such settings.