Try doing the select_related() at the end Remove the first use of it and then after the loop add this: employees = employees.select_related()
I think that'll work? On Aug 7, 10:25 pm, james_027 <[EMAIL PROTECTED]> wrote: > hi, > > I am doing something like this > > params = request.GET['name'].split() > employees = Employee.objects.all().select_related() > > for p in params: > employees = employees.filter(Q(firstname = p) | Q(lastname > = p)) > > the query is fine but when I look at the connection.queries django > still is not using join selects ... > > Any idea? > > james --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
