If it was me, I'd eneable oracle events trace and look at the plans and wait times for the two executions.
There are a few ways to do this, don't know of a web2py DAL specific one, but look for This article explains. https://oracle-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof On Sunday, 8 November 2015 05:16:31 UTC, tomt wrote: > > Hi, > > I encountered really slow responses when I was using my web2py app to > access an oracle database. I tried to use dbstats in response.toolbar to > measure this, but it wouldn't show the sql or any timing information. I > decided to try downgrading to an older web2py version, 2.11.2, and noticed > a dramatic change. > > web2py 2.11.2 query took 4 seconds > web2py 2.12.3 query took > 2 minutes > > I've tried this several times, with the same result. Were there any > changes in web2py that could account for this? > > The query I am running was passed to sqlform.grid > > soequery = ( (db2.soe_tdb.utctime > fromdate)&\ > (db2.soe_tdb.utctime < todate)&\ > (db2.soe_tdb.stationname.belongs(stationlist))&\ > (db2.soe_tdb.pointnumber == db2.statuspoint.pointnumber)&\ > (db2.statuspoint.pointaccessarea == > db2.accessareaassignment.setnumber)&\ > (db2.accessareaassignment.referencename == 'SOE')&\ > ~(db2.statuspoint.pointname.like('%@%')) ) > > orderby = [db2.soe_tdb.utctime] > > grid=SQLFORM.grid( > query=soequery, > deletable=False,editable=False,details=False, > searchable=True,fields=fields,headers=headers, > paginate=10,csv=False,maxtextlengths=maxtextlengths, > orderby=orderby, > ) > > Please let me know if there is any other information that I could provide > to try to resolve this. > > Thanks in advance, - Tom > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
