Hello, We’ve been debating the performance of “standard” Python vs. async <https://docs.python.org/3/library/asyncio.html> Python lately, in the context of db-backed web services. For web services, the blog Async Python is not faster <https://calpaterson.com/async-python-is-not-faster.html> provides interesting numbers, and @zzzeek back in 2015 wrote a blog Asynchronous Python and Databases <https://techspot.zzzeek.org/2015/02/15/asynchronous-python-and-databases> which suggests similar findings.
Furthermore, our own initial experiments indicate that running async Python isn’t actually faster, and we’re now diving a little deeper into the I/O behavior <https://en.wikipedia.org/wiki/I/O_bound> of our applications to understand their bottlenecks. Anyway, I’m curious about the communities *recent* experiences wrt. async Python and databases? With the just-released Python 3.11 <https://docs.python.org/3.11/> planning to address performance <https://github.com/faster-cpython/ideas/blob/main/FasterCPythonDark.pdf> (async performance?) we may see changes of the aforementioned numbers, or maybe not… Much thanks, Jens -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/75f8ccee-9f9e-4733-ba86-c78ceac538ean%40googlegroups.com.
