Re: [Mailman-Developers] Multiple REST servers
![](https://secure.gravatar.com/avatar/173371753ea2206b9934a9be1bdce423.jpg?s=120&d=mm&r=g)
On May 19, 2017, at 07:59 PM, Aurelien Bompard wrote:
Have you done any other analysis on where the bottlenecks are? Is it CPU, db, I/O?
I haven't investigated properly but it seems to be the database (which is on another host).
That's interesting because most of that runs through SQLAlchemy. I wonder if it's a general problem with the way we integrate with that, or if there are specific queries that are inefficient. I have no doubt there's room for improvement on the latter, but we'd have to do the instrumentation to find out.
Interesting. I wonder if we can have SQLAlchemy play well with asyncio, I haven't tried that before.
Me neither! asyncio is pretty new, so we're seeing lots of efforts to async-ify more parts of the ecosystem. I don't know whether the SA folks are looking into that at all. A general search shows some interesting projects and discussions on the topic.
There is still a gunicorn.py file in the contrib directory, but I haven't tested it either.
I tried to get it to work but had problems. I'm really interested in seeing if we can leverage uvloop for improved performance.
-Barry
participants (1)
-
Barry Warsaw