I have a table that represents a group, which has permissions on a 
row-by-row basis. User belongs to certain number of groups, and the rows 
into the table are kept for convenience sake. I would like to screen that 
list of rows for a specific permission and exclude those rows from the 
list. The code looks like this:

for row in rows:
    if not auth.has_permission('update', db.my_table, row):
        rows.remove(row)

Problem is, the auth.has_permission is slow ... on the order of 1.5 seconds 
when scanning a half-dozen row entries. my_table has around 150K rows. How 
do I speed this up?



-- 

--- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to