You might eke a little more speed out when you’re searching for linking rows by using an empty q.fetch_only() when doing the initial search for linking rows, e.g. the customer and location searches. That way you get the row id for testing for linking rows, but none of the other associated data for the row (which you don’t need in this case).
1 Like