It does look like there is a pure python implementation of TDS called pytds, which may actually work... the hard part would be getting web2py to use it...
On Wednesday, November 6, 2013 5:15:57 PM UTC-7, Derek wrote: > > Yea, I'm working on a communication layer for pyodbc or pypyodbc which > will handle requests with gevent, thus your application should yield > properly, but it's not available just yet, and it won't necessarily be a > drop-in replacement for pyodbc though. In the meantime, this is usually > good enough, and you can set timeouts for the queries and connects, but > that would be a change to the DAL. > > On Wednesday, November 6, 2013 4:50:33 PM UTC-7, Niphlod wrote: >> >> >> >> On Thursday, November 7, 2013 12:23:06 AM UTC+1, Derek wrote: >>> >>> Ah, if you are on Windows, I would recommend you run it with gevent >>> instead of rocket, it should be faster than even apache. >>> >>> unfortunately it doesn't work as happily as it should: if you're using >> any non-green module (he's working with mssql, hence either pyodbc or >> pypyodbc, that are not), those libraries don't "yield", so you block all >> other greenlets in the meantime. >> Without an upstream proxy balancing to multiple gevented web2py(s) if you >> have a "blocking" query to the database you queue up basically all other >> connections. I guess that without an apache ProxyBalancer (or a much >> yummier gunicorn, as it stands due in two >> months<https://github.com/benoitc/gunicorn/issues/524>) >> those web2py windows apps with non-green modules will run more >> "concurrently-friendly" with any "old" threaded webserver. >> >> -- 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/groups/opt_out.
