why does VDB need all models to be loaded that it can be used

lxjsj Jul 14, 2015 11:25 PM

In my VDB, I have defined many models, but when I deploy the VDB, from log I can see Teiid start to load the models' metadata.

I find that VDB can only be available when all models are loaded, sometimes it will take a long time to load all models metadata,

by the way if one of the models failed to load, the VDB can not be activated. why does VDB need all models to be loaded that it can be used.

1. Re: why does VDB need all models to be loaded that it can be used

rareddy Jul 15, 2015 12:40 AM (in response to lxjsj)

Because any view in the VDB or any user query can be written using any tables(s) from any models. For that all models need to be loaded for their metadata. VDB is completely defines a database, not individual model inside VDB. if you want define multiple VDBs with one model in each then define a composite VDB that imports each of the models individually, that way you are not loading all the models all the time, just ones you need.
Actions