On Nov 21, 2012, at 3:53 AM, ?manu* wrote:
> Suppose I have a queryset qs. For paginating purposes I need to do something like:
>
> count = qs.count()
> qs = qs[0:100]
>
> Unfortunately this executes the query twice, which I don't want.
Are you sure? This is such a common pattern that I suspect that it's not slower than making it into one query. I ran some tests on the slowest query I have, and the two statements were faster than trying to combine them. 0.2 + 1.5 sec vs. 1.9 sec.
You are right! (thanks also to Javier). It is not clear to me how it is possible but effectively it seems that the two queries are not slower than a single one...
Thank you also for the other answers.
E.
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/zylmsQNJeDoJ.
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