Hmm, I was suggesting that you could replace the whole DB driver with
a webservice implemented with twisted, if you rule out threads then
with ampoule doing it with a process pool and consume this webservice
with the tornado side asynchronously.
I see. I'm sorry, I misunderstood. So this would be a wrapper around
PostgreSQL. Very interesting idea. (In this case, I'm not sure how to
safely manage transactions.)
production level example thread pool based DB API:
Just to give you some ballpark figures, I'm running a game server with
a daily peak of about 1500 parallel permanent connections and 50k
games played every day (avg game duration 13min, peak request
frequency close to 100req/sec) with a lot of statistics going into a
MySQL DB on US$2k worth of hardware. Twisted as basis sitting atop
FreeBSD, started the latest version in March, its running since then,
no restarts, no reboots, no problems.
Thank you.
--
http://mail.python.org/mailman/listinfo/python-list