Thanks Michelle and Niphlod for your good advice and explanations. With 4 users connected the load from the ajax call is now down to 40%. I can live with that for this application.
FWIW, I decided to adopt a name prefix, "no_DAL", to tell web2py not to evaluate the models. That makes my test at the top of db.py look like if request.action == None or (not request.action.startswith('no_DAL')): db = DAL('sqlite://storage.sqlite', lazy_tables=True) etc ... Saves me having to remember to add new functions to a list to be checked in db.py. On Thursday, February 13, 2014 4:52:24 PM UTC-5, Michele Comitini wrote: > > If the session is still valid requires_login does not read the db but > session.auth so you should be fine, but I am not sure and in any case it > could change in the future. > You can remove it and check explicitly for "session.auth.user is not None" > in the body of the ajax action avoid unauthenticated users. > > > 2014-02-13 22:29 GMT+01:00 Michael Ellis <michael...@gmail.com<javascript:> > >: > >> That looks worth trying. Will I need to also remove the login_required >> decorator from my ajax function? >> >> >> On Thursday, February 13, 2014 3:57:02 PM UTC-5, Michele Comitini wrote: >>> >>> >>> >>> db = None >>> def setup_dal(): >>> db = DAL(...) >>> db.define_table(...) >>> db.define_table(...) >>> return db >>> >>> if request.controller!='<the frequent ajax controller> and >>> request.action!='<the frequent ajax action>': >>> db = setup_dal() >>> >>> >>> -- >> 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+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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/groups/opt_out.