Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1803

VDB deployment in EDS can be extremely slow based upon indexing needs

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 7.1.1, 7.2, 7.3, 7.4
    • 7.6
    • Server
    • None
    • Hide

      Deploying a VDB w/a large amount of schemas will expose this problem. It is extremely apparent when deploying to Solaris systems in particular.

      Show
      Deploying a VDB w/a large amount of schemas will expose this problem. It is extremely apparent when deploying to Solaris systems in particular.

    Description

      Problem:
      The index metadata loading logic is not well optimized. In short, each time a call to IndexMetadataFactory.queryIndex is made the blocks are fully scanned. For small VDBs there isn't much of an issue because of the block caching logic, but during a vdb deploy we could be constantly re-reading data from the files.

      Possible solution:
      The IndexMetadataFactory loading strategy should be made aware of the index file per schema strategy so that scans can be made per schema rather than against all index files.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-jolee Johnathon Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: