Optional key relationships to speed up listing

[Draghmar]

Is your feature request related to a problem? Please describe.

I really like having key relationship available on listing to quickly check what the target of the Foreign key constraints is. But it slows down listing, which is especially visible on slower connection, with more latency and more related columns in one table.

Describe the solution you'd like

It would be great to have relations as a optional thing. I'd like have it the same way I can show target column instead of ID when changing it under Extra options. There could be a checkbox or radio that would relist to show the relationships.

As a bonus, it would be even better if it happen after main listing would load. Some AJAX/Fetch that would add relationships to the list. This way we could have listing available as fast it can be shown and later, in the background, linking would happen.
Something similar happens on the table tree, where opening direct link would show main content and tree would be loaded after that.

Option with red marker is what I'd add. There could be a config setting where we could set which one we'd like to have as a default when listing rows. Changing it from off to other would either reload whole list or fetch relationships with AJAX/Fetch, which would be preferred. So in case of the screen below all those columns with id_ prefix wouldn't have relationships loaded. Only by changing this potential option it would end up like in the screen.

Additional context

• phpMyAdmin version: 5.1.2 and 6.0-dev

[kamil-tekiela]

Would you mind adding a screenshot pointing to the thing you are describing?

[Draghmar]

Sure thing - edited main post with additional description as well.