Abnormal increase in size and performance reduction due to multiple Versions

GauravT_*15211

Hi All,

 

I am currently seeing dramatic increase in size of the model probably due to the usage of the version. Due to the problem I am trying to solve I require many versions (upto 100). This leads to the model size increasing 10 times as fast as using other normal lists as dimensions. for example my mode has 17Mn cells and size is 1.6GB whereas expected is around 200MB. Also I noticed performance hit due to high number of versions present in the model. 

Can anyone confirm this is a plausible explanation of the aforementioned behavior. I suspect this is largely due to internal implementation and underlying structure of the Versions . Thanks

DavidSmith

It does all depend on the dimensionality of the modules containing versions.  The size increase is not just about the increase in the versions list but the product of all of the dimensions where Versions apply

So taking a module that has 3 lists, time and versions with the following members

List A = 5

List B = 10

List C = 100

Time = 50

Versions = 10

The number of cells would be 5*10*100*50*10 = 2,500,000

 

Adding 1 more Version, the cell count would be 5*10*100*50*11 = 2,750,000 so the increase is proportional

 

The Gb size then depends on the formatting of line items:

Boolean – 1 Byte

List, Date, Time – 4 Bytes

Text, Number – 8 Bytes

I hope this helps

David