3 ms·
It wouldn't. Databases are fast, python is slow.
by patrec 3y ago
It wouldn't. Databases are fast, python is slow.
- patrec 3y agohttps://techspot.zzzeek.org/files/2015/pymysql_runsnake.png https://techspot.zzzeek.org/files/2015/pymysql_runsnake.png
- jerrygenser 3y agoNetwork is slow. So you are waiting on the db for most of a request lifecycle.
- pjmlp 3y agoThat depends on how much work is done in stored procedures instead of wasting network traffic and client CPU cycles to process the results.
- patrec 3y agoNetwork latency within an AWS AZ is <1ms and throughput is in the GB/s range. What percentage of python webapps do you think are hitting this as their latency and throughput limit? (Assuming effective DB use of course, i.e. not doing dozens of DB roundtrips to server a single result or getting megabytes of data and filtering on the client etc.)
- chaoz_ 3y agoTrue... When I measured something similar in a large python app, the biggest chunk of time went into python object serialization/deserialization.