Re: [web2py] Re: DAL performance vs executesql

2013-07-08 Thread Anthony
n 24 June 2013 14:58, Michael Hall > wrote: > Was there ever a fully working solution proposed or discovered for using >> executesql with grid and smartgrid? >> >> > I don't know of any. What I sometimes do is to use create views or tables > containing the results of complicated SQL-queries and

Re: [web2py] Re: DAL performance vs executesql

2013-07-08 Thread Johann Spies
On 24 June 2013 14:58, Michael Hall wrote: > Was there ever a fully working solution proposed or discovered for using > executesql with grid and smartgrid? > > I don't know of any. What I sometimes do is to use create views or tables containing the results of complicated SQL-queries and use them

[web2py] Re: DAL performance vs executesql

2013-06-24 Thread Michael Hall
Was there ever a fully working solution proposed or discovered for using executesql with grid and smartgrid? On Friday, 22 June 2012 07:54:05 UTC+1, pbreit wrote: > > I have an app where I pull down 5,000 records. I started with DAL and > db.item.ALL and it was taking around 4 seconds. I added 5