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 [email protected].
For more options, visit https://groups.google.com/d/optout.
