> > Anthony, I'm not supposed to retrieve tens os thousands records from a > single query in a web app.
Mostly true, but not always: https://groups.google.com/d/msg/web2py/A11z4UdMaIc/882_shAVk4UJ Of course, if you've got a busy site with lots of queries, it can add up even for relatively smaller result sets. > Anyway, we can execute raw SQL statements via DAL, right? > Yes, it's possible to create your own manual workarounds -- this would just be an added convenience. At least a basic version of this shouldn't be hard to implement -- just return the raw db response without any further processing. Anthony
