Re: Help me with this query

Thanks guys. The pyodbc option seems to be the best as i've discovered that QuerySet cannot also be random.shuffleD

On Fri, Dec 23, 2011 at 11:09 PM, Python_Junkie <software.buy.design@gmail.com> wrote:

You can use the full functionality of sql and python by executing sql
queries using the pyodbc module.

The module is documented at this url
http://code.google.com/p/pyodbc/

You can combine sql and python logic and not have to be constrained by
the abstraction of raw sql or the ORM.
in your django views

Capture the data/transformation in python dictionaries to be rendered
in the template

On Dec 23, 4:48 pm, Sebastian Goll <sebastian.g...@gmx.de> wrote:
> On Fri, 23 Dec 2011 20:16:11 +0100
>

> Babatunde Akinyanmi <tundeba...@gmail.com> wrote:
> > 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.
>
> To randomly select 10 records from your model, you can also use
>
>   Model.objects.order_by('?')[0:10]
>
> This translates loosely to something like this SQL statement:
>
>   SELECT … FROM … ORDER BY RANDOM() LIMIT 10
>
> Beware that this might be an expensive and/or slow query, depending on your database backend. Unfortunately, I don't know how each database backend compares. See:
>
>  https://docs.djangoproject.com/en/1.3/ref/models/querysets/#order-by
>
> Regards,
> Sebastian.

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

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