Re: Trouble expressing a query in the ORM

2011-09-09 Thread Pewpewarrows
Tim Shaffer's response would have you doing N+1 queries, and having to loop through all of your Target objects in-memory. Technically it would work, but as soon as you have a decently sized amount of data in there it'd slow to a crawl. The best way I can see to do this straight with the Django

Re: Trouble expressing a query in the ORM

2011-09-09 Thread Pewpewarrows
I don't understand the 10-15 limit either. I've done giant "in" queries in the past that perform fine with large data sets and proper indexing. -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://gr

Re: Trouble expressing a query in the ORM

2011-09-09 Thread Pewpewarrows
The best way I can see to do this straight with the Django ORM is: >> >> prop_dates = >> Target.objects.annotate(latest_property=Max('property__export_date')).values_list('latest_property', >> >> flat=True) >> properties = Property.objects.filter(export_date__in=prop_dates) >> > > Let say I h

Re: Django on MediaTemple (dv) 4.0

2011-09-09 Thread Pewpewarrows
>From what I understand, MediaTemple's (dv) server is just a normal VPS that you would get from any other hosting company. Setup your environment and website how you would on any other production server. If you're asking about how to setup Django on a *nix server in general: look into virtualen