Skip Navigation

[Resolved] Toolset relationships

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+01:00)

This topic contains 1 reply, has 2 voices.

Last updated by Nigel 9 months, 1 week ago.

Assisted by: Nigel.

Author
Posts
#2705958

What is the difference in the one-to-many relationships of
1/ - Migrated (original version)
2/ - current one-to-many version
3/ - Post Reference Field

For example, how are they stored, which has a faster retrieval in a view, what is best in a large database or any other pros or cons ?

#2706229

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+01:00)

Hi there

If you have old Types 2.x relationships and ran the migration wizard (there were actually 2 such wizards, in Types 3.0 and again in 3.4) then the database structure is the same as for newly created relationships, so there is no difference between 1 and 2.

Details of the relationships are stored in the table wp_toolset_relationships, while the connections between posts themselves are stored in a combination of wp_toolset_connected_elements and wp_toolset_associations.

The post relationship field is just another way of creating a one-to-many relationship field, where the differences are just in the UI about how you enter the data (the simpler UI is only shown on the child post with a dropdown to select a parent). The data is stored in just the same way as "true" one-to-many relationships, in the same tables.

Meaning that functionally, in terms of performance or how to retrieve and display related content, there are no differences.