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.

Reply via email to