3 ms·
> Python is Very, Very Slow compared to your database I never actually tried to measure this, so I have 2 questions: 1. Have I understood correctly that autho
by krick 12y ago
> Python is Very, Very Slow compared to your database
I never actually tried to measure this, so I have 2 questions:
1. Have I understood correctly that author implies that webapp and DB are running on one server? But that's usually just not the case!
2. Does anybody have an idea, of how we could compose more or less realistic benchmark for this, preferably in language-agnostic manner, so I could write a few scripts, connect few databases on multiple hosts, run it and see, how expensive all this stuff actually is, app-code/db performance wise?
- zzzeek 12y ago> Have I understood correctly that author implies that webapp and DB are running on one server? But that's usually just not the case! no. Please see the benchmark suite where I ran the async/threaded performance tests both on the same machine as well as on different machines. As for the PyMySQL example, I can assure you, running it on the same machine, different machines, whatever, you'll see something very similar as far as that Python profiling result.
- lmm 12y ago1. No. 2. https://www.techempower.com/benchmarks/ https://www.techempower.com/benchmarks/ is the best effort I've seen. Still has all the problems of benchmarks (that is, it should be seen as giving an upper bound for performance of a particular tech stack, which you will almost never reach in practice), but it at least gives you end-to-end numbers on something like a realistic problem.