On Fri, Apr 11, 2014 at 3:51 AM, Conrad Rowlands <conradjrowla...@googlemail.com> wrote: > I would still be keen to know if there is any know method that would allow > me to load this data using only the 1 queries bringing in all of the related > fields in the original query.
what's the first query about? probably it's part of the authorization process, so it might not be appropriate to reduce to just one query. in any case, the exact number of queries is irrelevant. the important thing is to keep it constant for any data size. for example, a slightly complex task could easily need 10 queries but the final throughput you get from the system would be almost the same if it's 10 queries or just 1, as long as it's not (n+1) as you had before. of course, you still have to be sure the indexes are optimal to keep each query nice and tight! -- Javier -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFkDaoQ7niYrRkDSY7PwdyqKoc172R4X24h%3DYAodT4SaQBcXGA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
