[web2py] Re: View SQL generated by SQLFORM.grid

2016-05-04 Thread Jim S
I did what you suggested and I get this statement: SELECT workorder.workorderId, workorder.parent_workorder, workorder.siteId, workorder.created, workorder.needed, workorder.productId, workorder.productName, workorder.productSiteId, workorder.pullFromStock, workorder.bomId, workorder.quantity,

[web2py] Re: View SQL generated by SQLFORM.grid

2016-05-04 Thread Niphlod
response.toolbar() shows db statistics, I guess is the fastest method out there. On Wednesday, May 4, 2016 at 9:32:10 PM UTC+2, Jim S wrote: > > I pass a query to SQLFORM.grid. Is there a way to see the SQL that last > executed on behalf of the grid? I'm trying to tune my db for the SQL > sta