What is best for performance between these choices?

[ydd]

Hi all,

I’ve read that it’s better for performance to separate tables with heavy data fields. But I’d like to know how to separate these tables.

So I want to create a table Project123456 and I’ll put heavy fields in Project123456-extended. My question is: how do I link the two tables?

First way of linking the two pages

Second way of linking the two pages

What do you think is best for performance? Or is it the same?

[juicebox]

For this particular setup, I’d recommend linking both ways. There should be no tangible impact to performance and you’ll find it easier to build dynamic queries if it’s linked both ways.