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 fields to the > select() which got it down to around 2 seconds. Then I implemented the same > thing with executesql and got it down to 500 ms. > > So, selecting only the fields you need is a good optimization. But going > with raw SQL is much better. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
