Massimo, They map into one sql query and they execute on each record on the db > side. I do not know how efficient they are. >
It appears to me that it would be really helpful if we could set a flag so that Web2py would log all the SQL statements that it executes. If the log could include source code reference (to the controller/model) and execution time then it would be really helpful for performance work as well as working out what is happening under the covers. Without this we are never going to be able to answer the questions about efficiency. Thanks Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk