I have a requirement, just to have 50 random records from table without any order. I don't want to use any orderby condition as number of records in tables is very large and any ordering is over-head cost when I need random records. A query like *db().select(db.person.name, limitby=(0,50)) *automatically applies order by clause to the query so resultant query becomes *db().select(db.person.name, orderby=db.person.id, limitby(0,50))*.
What is the rational behind appending orderby clause automatically ? Is there anyway to bypass this? P.S. I have some other params which will make sure, records are not repeated when query is run multiple times without any ordering.
