[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1200) Synchronizing a VDB takes too long in 7.4.2

Synchronizing a VDB takes too long in 7.4.2 ------------------------------------------- Key: TEIIDDES-1200 URL: https://issues.jboss.org/browse/TEIIDDES-1200 Project: Teiid Designer Issue Type: Bug Components: Validation, VDB & Execution Affects Versions: 7.4.2 Reporter: Debbie Steigner Assignee: Barry LaFond Fix For: 7.7, 7.6.1 Attachments: org.teiid.designer.core.patch, org.teiid.designer.dqp.patch, org.teiid.designer.vdb.patch, org.teiid.designer.vdb.test.patch, org.teiid.designer.vdb.ui.patch, TEIIDDES_1200.zip, UdfManager.java.patch, UdfUiPlugin.java.patch, VdbUtil.java.patch Synchronizing a big VDB in version 7.4.2 (JBDS 4.1.1) takes 30 minutes versus 2 minutes in 7.1.1 (JBDS 4.1.0) Investigating/debug noted 2 areas. 1) New UdfManager is not caching a FunctionLibrary and each SQL validation is creating a new instance. (needs a fix) 2) Synchronizing a VDB is hammering the ChecksumUtil.computeChecksum() during the VDB's resource build processing 3) PreviewManager is using a new Vdb() object to determine if "preview = true" and version #. However, it's heavy weight and currently the Vdb() is registering for events, but is not being Unregistered.