Friday, December 23, 2011

Help me with this query

Hello,
How can I get the ORM to do the equivalent of this sql query with the
result being a QuerySet:

SELECT * FROM table LIMIT expr.

I know I can use objects.raw() but I need to shuffle the results and
RawQuerySet objects do not have __len__() making it impossible to
random.shuffle.

I actually have a database with thousands of records from which I have
to randomly select just 10 records from the thousands during every
query. Because of efficiency, I use the normal select with limit query
using a random number as offset and 200 as the limit. Next, the idea
is to shuffle the results and use the first 10 numbers.

Thanks for any assistance

--
Sent from my mobile device

--
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.

No comments:

Post a Comment