Eager loading in global replicators

[indykoning]

Description

We have a global created that links a Runway model to additional Statamic content.
In our example this is "Tooltip Content" with additional information attached to a Product Attribute.

This is done using a replicator so multiple attributes can get a tooltip

However attempting to show all these tooltips has a performance impact. since we're accessing the "attribute code" of the Attribute which is a runway model.

Looping over these items causes a database query per tooltip. Is there any way to eager load these relationships in a single query. Eager loading between runway models can be solved using https://runway.duncanmcclean.com/resources#eager-loading but i'm unsure if it's even possible between a Statamic entry and a Runway model.

Has anyone run into this before, is there any way to fix this?

---

Our current workaround is caching the result.

Environment

Environment
Laravel Version: 12.64.0
PHP Version: 8.4.18
Composer Version: 2.9.8
Environment: local
Debug Mode: ENABLED
Maintenance Mode: OFF
Timezone: Europe/Amsterdam
Locale: en

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: null
Cache: file
Database: mysql
Logs: stack / single
Mail: smtp
Queue: redis
Session: file

Storage
public/storage: NOT LINKED

Sentry
Enabled: YES
Environment: local
Laravel SDK Version: 4.24.0
PHP SDK Version: 4.23.0
Release: 9beede70
Sample Rate Errors: 100%
Sample Rate Performance Monitoring: NOT SET
Sample Rate Profiling: NOT SET
Send Default PII: ENABLED

Statamic
Addons: 17
License Key: Not set
Sites: 4
Stache Watcher: Enabled (auto)
Static Caching: Disabled
Version: 6.27.0

Statamic Addons
statamic-rad-pack/runway: 9.6.1
statamic/eloquent-driver: 5.10.0
tdwesten/statamic-builder: 3.0.9

Statamic Eloquent Driver
Addon Settings: file
Asset Containers: file
Assets: eloquent
Blueprints: eloquent
Collection Trees: eloquent
Collections: file
Entries: eloquent
Fieldsets: file
Form Submissions: eloquent
Forms: eloquent
Global Sets: file
Global Variables: eloquent
Navigation Trees: eloquent
Navigations: file
Revisions: eloquent
Sites: file
Taxonomies: file
Terms: eloquent
Tokens: eloquent

[duncanmcclean]

Can you give #848 a try?

[indykoning]

Legend! This indeed heavily reduces the amount of queries ran in my cases. The specific case with the tooltips i mentioned are now reduced to a single query! And i feel the difference in speed already.

[duncanmcclean]

Great - just tagged v9.6.2