Optimizing a database query with a selection of rows that contain relationships?

Question

Laravel

Hi all. There is a controller to fetch all records of the Survey model, and each Survey has a Respondents relationship. The controller finds all Surveys and passes them to the transformer (SurveyTransformer), where each Survey is added with the respondents_count field, the number of respondents in the ManyToMany relationship. But it turns out to be very expensive: for each Survey, access the database to find out the number of respondents belonging to it.
How can this moment be optimized? Thank you in advance.

Answer 1

To do this, there are methods with, load
If only the number is needed, then withCount