Sorry. I do not fully understand the question.
rows = db(db.a.status==False).select(db.a.md5,orderby='<random>',limitby=(0,
150))
*is the same as*
* for row in db(db.s.status==False).select(db.s.md5):
md5_list.append(row['md5'])
random.shuffle(md5_list)
md5_list=md5_list[:150]*
The former as you say is more efficient. Does it not work for you? Which
database?
On Friday, 19 July 2013 13:20:45 UTC-5, Nam Soo In wrote:
>
> I want to write select statement with random and limited number
> It looks like that.
>
> db(db.a.status==False).select(db.a.md5,orderby='<random>',limitby=(0, 149))
>
> what it dose is it dose random on result and take 150 rows
>
>
> if you write it in python
>
> * for row in db(db.s.status==False).select(db.s.md5):
> md5_list.append(row['md5'])
> random.shuffle(md5_list)
> md5_list=md5_list[:150]
> *
>
> *
> *
>
> *What is the shortest process time to deal with this problem.*
>
> *Thank you in advance.*
>
> *
> *
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
