Hi all, Just to support/commiserate with Kevin, we have a SaaS app that has 80 tables, with 980 lines of code in a db.py model file. It runs remarkably quick (against a MySQL database on a relatively low powered develoment server) for the amount of work it does.
I've grouped the tables into a series of functions that right now, all run every time. the whole model takes 200ms to run of which the table definitions takes 85 ms When I get the inclination I'll map the models to the groups of tables it needs to open to speed things up - but that's for a rainy day as we don't have performance 'problems' - yet. But my question really is what are the opportunities for global caching of data for single users or groups of users or the entire application, for the duration of sessions and for all time. For example, MS Active Server pages had session object and variables, and an application object and variables shared across users. Is there any concept of this in Web2py or would we have to get 'under the bonnet of WSGI' to reach this kind of feature? I'm happy to trial any proposals for improving the big db.py problem, by the way. Thanks, Paul.
