For text values there is no difference. For others, like dates, it is the variable value converted to text. This way regerdless the variable type, you can still retrive the value with ValueCache.
It definitely makes it easier to fetch values from a single column and also if u notice the Datatype For ValueText its nVARCHAR(MAX) and For Cache its nVARCHAR(60) so its will have positive impact on Performance as well.
Understood. Thanks to both of you!
Actually - there is a difference. As Ravi stated, ValueCache only stores a maximum of 64 characters vs. max for ValueText.
Depending of what version of EPDM you are using, you might find ValueText declared as ntext.
In any event, if the number of characters in ValueCache exceeds the limit, the next column IsLongText will be set to 1.