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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.6
    • 7.1.1, 7.2, 7.3, 7.4
    • 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.

      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.

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

              Created:
              Updated:
              Resolved: