QVD Load fast, but linking model takes a long time
I load 16 QVD files to build a model of which the biggest DVD at the moment is 500 MB, another 117 MB and the rest of the QVD files are small in comparison, i,e, 20, 11, 9, 5 and 1 MB and smaller.
Loading the QVD files is fast: 1min and 30 secs, however after the QVD's are loaded, I assume QlikView is building or linking the model and this takes very long… At this point in time I have not waited long enough for it to finish, since I think there's something wrong ?
Re: QVD Load fast, but linking model takes a long time
Perhaps your datamodel isn't proper and there are synthetic keys. These calculation could take many hours .... I suggest not to load all qvd at once then step by step and then look in the log-files and the table-viewer.