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, workorder.uom, workorder.mixerId, workorder.approvedById, workorder.actualQuantity, workorder.completed, workorder.hasMolasses, workorder.brixLevel, workorder.hasUrea, workorder.ureaConcentration, workorder.rfLevel, workorder.phLevel, workorder.tankNumber, workorder.sent, workorder.allowToFinalize, workorder.temperature, workorder.transaction_date, workorder.scale_weight FROM workorder WHERE (workorder.workorderId = 47291) LIMIT 1 OFFSET 0;
about 43 times. And about an equal number of select statements on auth_membership and auth_permission But, nowhere do I see the SQL Statement that should be driving my SQLFORM.grid SELECT statement. I know it should include my 'product' table (I have it specified on the 'left' argument). But, searching the page, there are no references to it. Any way to get it from the grid object returned from SQLFORM.grid? -Jim On Wednesday, May 4, 2016 at 3:23:52 PM UTC-5, Niphlod wrote: > > 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 >> statement used to show the list of records. >> >> -Jim >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
