auth_group is for groups. auth_permissions is for permissions. as any other table in your db, the problem is not the # of records, rather than what query you need to do on those.
On Wednesday, June 17, 2015 at 10:42:57 PM UTC+2, Alex Glaros wrote: > > db.auth_group is doing double duty in my app as a role table for > everything in addition to permissions. Examples: (a) Partnership roles with > the organization. (b) Employee roles such as SME for a project. There may > be millions of people reading/writing concurrently. > > Is there anything different about auth tables from any other table that > would slow things down? (will be on Postgres/Pythonanywere.com) > > Can it handle as many records as regular table? > > thanks, > > Alex Glaros > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.