On 7/22/07, Patrick <[EMAIL PROTECTED]> wrote: > What would be the most efficient way to get 10 top authors using Django > db-api? Or should I switch to raw SQL to handle this query?
The most efficient way would be to use raw SQL. There are a couple queries like that on djangosnippets.org to get top-rated snippets, most-bookmarked snippets, etc., and you might want to look at those as examples of how to do it: http://cab.googlecode.com/svn/trunk/managers.py The "most_bookmarked" method on the BookmarksManager, and the "top_rated" method on the RatingsManager both do this sort of query. -- "Bureaucrat Conrad, you are technically correct -- the best kind of correct." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
