Optimizing search with multiple linked rows

[ejl]

@jshaffstall

Using q.fetch_only like you are might be as good as you’re going to get without denormalizing your database structure.

Edit: unless you can use q.fetch_only to tell it not to fetch the location column for the customer link inside the location row. The circular reference might be taking extra time?

Right, I have the query down to a stable ~ 3 seconds now, which is good enough for the time being.

In regards to the circular reference, that might be a thing, I’ll have a look.

Thank you very much, for taking the time, to have a look!
Much appreciated!