Hi everyone, First of all I would like to say thanks to Massimo and the entire community for the great job you're doing :)
I am building a Reporting application for my graduation paper for an example company with Web2Py. I am using MySQL (a reporting DB and a denormalized datamart for ROLAP to use for Python Cubes http://cubes.databrewery.org/ ) and Web2Py. I've managed to set up everything to get it working but I'm not sure whether I'm doing it the *right* way. Currently, I have the following setup: *Controller* def getcostdata(): db.executesql (*get data on costs, for example*) transform data plotting library internals *View* view data using plot library/html Questions: 1. Should I use session variable and retrieve data from a dictionary - build some kind of cache (that expires at a certain interval) so multiple views won't run the same query multiple times needlessly? 2. I've seen some people say that functions like this should be placed inside a model or a module? Is there a difference in performance : controller vs. model vs. module? 3. I would like to reuse the information from a function in another place in my app but not load it needlessly -> module? 4. How can call a function from another controller ? Hope this makes sense. Thank you in advance, Constantin -- 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.