Data type : Ref or Enum-ref is better for sync time ?

[kvngo94]

Hi everyone, 

Notice Ref creates virtual colunmn automatically, so if I choose Enum-ref it is better for sync time ?  (down side is that I then can't click to the [ref-id] column to link to the row).

Thank you. 

[Steve]

There is no practical difference except possibly with huge datasets.

[kvngo94]

Hi Steve, 

Could you advise how huge of the datasets that it will impact the sync time ? like how many rows...

Thanks for the answer.

[Koichi_Tsuji]

Enun - ref would give the better performance rather than normal ref for sure as enim ref will not generate reverse ref VC

[kvngo94]

Thanks Koichi for your answer!

[kvngo94]

Hi Koichi, could you advise me what if I use Ref but not show/hide the VC columns ? Does hiding the VC columns improve the sync time ? 

[Steve]

It's not possible to answer that question.

[kvngo94]

Thanks Steve!

[Koichi_Tsuji]

---

@kvngo94 wrote:

I use Ref but not show/hide the VC columns

---

It is impossible. Once you set the column type as REF, then reverse REF VC is always showing up. Even after you delete and save, then I comes up again. This is how REF column works.

[kvngo94]

Hi Koichi, 

But I still can hide it :

[Steve]

Hiding has no effect on sync time. The column value will still be computed, it just won't be visible to the user.