Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-715

Oracle metadata import using Designer takes long time for large schemas

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • Future
    • 7.1
    • Import/Export
    • None

    Description

      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.

      Attachments

        Issue Links

          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-921 Issue during importing of Oracle metadata when the schema is partitioned

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              Unassigned Unassigned
              rhn-engineering-rareddy Ramesh Reddy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: