Hi there,
Can anyone provide me with some suggestions on how to optimise web2py
for GAE?
At present the code I've got deployed (based on Version 1.96.3
(2011-06-06 16:16:02) seems incredibly slow.
I keep getting DeadlineExceededExceptions and timeouts for simple
request / responses like this:
121.73.240.51 - - [03/Jun/2011:14:23:16 -0700] "PUT /test.json HTTP/
1.1" 500 0 - "App/1.0 CFNetwork/485.13.9 Darwin/11.0.0,gzip(gfe)"
"app.appspot.com" ms=155137 cpu_ms=607 api_cpu_ms=0 cpm_usd=0.016884
loading_request=1 exit_code=104
2011-06-03 14:20:48.794
no file locking, this will cause problems
D 2011-06-03 14:20:55.690
no sqlite3 or pysqlite2.dbapi2 driver
D 2011-06-03 14:20:55.690
no pymysql driver
D 2011-06-03 14:20:55.694
no psycopg2 driver
D 2011-06-03 14:20:55.697
no cx_Oracle driver
D 2011-06-03 14:20:55.700
no MSSQL/DB2 driver
D 2011-06-03 14:20:55.703
no kinterbasdb driver
D 2011-06-03 14:20:55.707
no Firebird driver
D 2011-06-03 14:20:55.711
no informixdb driver
D 2011-06-03 14:20:55.715
no sapdb driver
D 2011-06-03 14:20:55.718
no cubriddb driver
D 2011-06-03 14:20:55.721
no zxJDBC driver
D 2011-06-03 14:20:55.724
no Ingres driver
D 2011-06-03 14:20:59.833
no couchdb driver
D 2011-06-03 14:20:59.837
no mongoDB driver
E 2011-06-03 14:23:16.094
<class 'google.appengine.runtime.DeadlineExceededError'>:
Traceback (most recent call last):
File "/base/data/home/apps/app/1.350865972846579479/gaehandler.py",
line 59, in <module>
import gluon.main
File "/base/data/home/apps/app/1.350865972846579479/gluon/main.py",
line 114, in <module>
rewrite.load()
File "/base/data/home/apps/app/1.350865972846579479/gluon/
rewrite.py", line 261, in load
load_routers(all_apps)
File "/base/data/home/apps/app/1.350865972846579479/gluon/
rewrite.py", line 352, in load_routers
if os.path.isfile(abspath(cpath, cname)) and
cname.endswith('.py'):
File "/base/python_runtime/python_dist/lib/python2.5/posixpath.py",
line 208, in isfile
st = os.stat(path)
I 2011-06-03 14:23:16.097
This request caused a new process to be started for your application,
and thus caused your application code to be loaded for the first time.
This request may thus take longer and use more CPU than a typical
request for your application.
The code I've deployed for the most part is extremely simple.
The example /test.json above reads in a email address (provided via
JSON) and responds with the persons username via JSON.
I would have expected this type of operation to take only milliseconds
but it's currently taking 155137!!!!
Any ideas or help on this would be totally appreciated,
Thanks in advance,
Matt
Also: Is there anyway to stop it from automatically attempting to find
all of the other drivers each time? (Aside from hacking the code
base.)
