[sqlalchemy] Re: sql expression performance is bad ?

2014-03-13 Thread Ni Wesley
1. Yeah, I do have index on app_key and device_token 2. I realized the issue with how I use sessions every request, so , later, instead of sessions, I directly call engine.execute where engine is initiated just once from another file. Seems no improvement compared to session... 在

[sqlalchemy] Re: sql expression performance is bad ?

2014-03-12 Thread Ni Wesley
In case of network problem. I test in a vlan. Here is engine ouput and my logging: DEBUG:devsrv:Got connection from ('192.168.1.7', 63181) One device connected:('192.168.1.7', 63181) Connection