]
Barry LaFond updated TEIIDDES-3123:
-----------------------------------
Fix Version/s: 11.1.1
Deploy XML VDB takes a long time.
---------------------------------
Key: TEIIDDES-3123
URL:
https://issues.jboss.org/browse/TEIIDDES-3123
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 11.1
Reporter: Matej Kralik
Assignee: Barry LaFond
Priority: Critical
Fix For: 11.1.1
Attachments: SourceColumnsProject.zip, screenshot.png
When I generate XML VDB from VDB, the designer adds "<metadata
type="NATIVE"/>" property to XML VDB. It causes performance issue
because deploy XML VDB takes a long time.
The time between deploy VDB (added to the repository) and set VDB to active:
With "metadata native" property: 3 minutes.
Without "metadata native" property: <1 seconds.
For this example, I use XML VDB (in the project from attachments) which connects to MS
SQL Server database.
When I use another connection with a lot of tables and schemas, it takes very long (more
than 30minutes).
I think that it is not necessary to add this property by default to all XML VDBs only if
it is necessary for specific VDB. For users who want to use this property will be good to
add a new checkbox to the 'options' tab in the 'Save as VDB XML file'
wizard. (screenshot)