Re: weird behavior in select_related

On Saturday, January 22, 2011 1:38:22 PM UTC, maraujop wrote:

Hi everyone,

I have been working on reducing DB queries in my project with great results. But I have realized that select_related in one of my models doesn't preload all the ForeignKeys and OneToOneFields, it preloads 3 out of 5. Actually the 3 preloaded are ForeignKeys and the other 2 are OneToOneFields. Before trying to reproduce this problem in a simplified schema, I need someone to confirm this is unusual.

If I do a select_related('names', 'of', 'the', 'five', 'fks') everything is loaded. Last thing I can say is that those OneToOneFields point models that reference back to model pointing at them, for performance reasons. I reckon this can be a bug.

Thanks, best regards

----

Miguel Araujo

@maraujop

It would have helped if you'd posted your model. If your relationships are defined as null=True, then select_related() doesn't follow them unless you specify them explicitly.

--

DR.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.