Re: [web2py] Re: DAL speed - an idea

2012-03-09 Thread nick name
On Friday, March 9, 2012 2:18:58 PM UTC-5, viniciusban wrote: > > Anthony, I'm not supposed to retrieve tens os thousands records from a > single query in a web app It's all a question of what each layer is doing. Let's say you have a database with 100,000 records. You need a summary: select su

Re: [web2py] Re: DAL speed - an idea

2012-03-09 Thread Anthony
> > 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 sma

Re: [web2py] Re: DAL speed - an idea

2012-03-09 Thread Vinicius Assef
Anthony, I'm not supposed to retrieve tens os thousands records from a single query in a web app. I would address this problem to app structure, instead of to DAL. Anyway, we can execute raw SQL statements via DAL, right? -- Vinicius Assef On Fri, Mar 9, 2012 at 4:12 PM, Anthony wrote: > mcm