Re: filtering by related object causes query to grind to a halt

2010-05-23 Thread Chris Withers
Okay, so I noticed that it's the following code, and it's only when I filter on user *end* event: Chris Withers wrote: queryset = TicketStatus.objects.filter(active=True) if user_id: queryset = queryset.filter(owner=User.objects.get(id=user_id)) queryset =

filtering by related object causes query to grind to a halt

2010-05-23 Thread Chris Withers
Hi All, I have the following models: class Event(models.Model): name = models.CharField(max_length=100) price = models.DecimalField(max_digits=4,decimal_places=2) class Ticket(models.Model): number = models.IntegerField(db_index=True) event = models.ForeignKey(Event) class