Re: Django db-api or raw SQL: getting top 10 blog posters

2007-07-22 Thread Patrick
On Sun, 22 Jul 2007 21:59:56 -0500, James Bennett wrote: > 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.

Re: Django db-api or raw SQL: getting top 10 blog posters

2007-07-22 Thread James Bennett
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

Django db-api or raw SQL: getting top 10 blog posters

2007-07-22 Thread Patrick
Hi, I have a small issue, which I'm not sure how to handle using Django db-api. This is part of my Blog model: class Post(models.Model): author = models.ForeignKey(User) ... What would be the most efficient way to get 10 top authors using Django db-api? Or should I switch to ra