News for hackers. Stuff that matters.
Re:Tcl is faster than Python for database benchmarking by bb88 on Tuesday November 01, 2022 @06:25PM (#33428500)
... for some definition of methodical that ignores multiprocessing.
Re:Tcl is faster than Python for database benchmarking by tyingq on Tuesday November 01, 2022 @07:08PM (#33429025)
Particularly since tcl threads don't share anything. It's one thread per interpreter.
Re:Tcl is faster than Python for database benchmarking by nine_k on Tuesday November 01, 2022 @07:14PM (#33429085)
I wonder why are these called "threads" then.

The very point of threads (as opposed to parallel processes) is the easy access to common memory and other resources.

Re:Tcl is faster than Python for database benchmarking by bb88 on Tuesday November 01, 2022 @07:28PM (#33429258)
In fairness, that is in the pipe for python for a release soon. One interpreter per thread.
Re:Tcl is faster than Python for database benchmarking by munch117 on Tuesday November 01, 2022 @07:57PM (#33429584)
Not quite, subinterpreters can contain multiple threads each. But you're right in that if you limit yourself to one thread per subinterpreter, then you should be able to get good multicore scaling that way, when more fully fleshed out subinterpreters arrive in 3.12. The trick then becomes how to efficiently communicate between them. Interesting times ahead.
Re:Tcl is faster than Python for database benchmarking by tyingq on Tuesday November 01, 2022 @11:24PM (#33431111)
Erlang is fairly famous for working in a similar way.
Re:Tcl is faster than Python for database benchmarking by amelius on Tuesday November 01, 2022 @07:17PM (#33429124)
You mean multiprocessing where communication goes either through serialization or through shared-memory where you have to use C-style programming and you lose all the advantages of e.g. a garbage collector and Pythonic datatypes?
Re:Tcl is faster than Python for database benchmarking by bb88 on Tuesday November 01, 2022 @07:32PM (#33429291)
Uh... did you like actually read his code? He has no shared state across threads. It's a perfect example for multiprocessing.
Re:Tcl is faster than Python for database benchmarking by insanitybit on Tuesday November 01, 2022 @07:54PM (#33429549)
Meh, mp is kind of a disgusting hack. Maybe it would have worked here but it's so easy to run into bullshit. Off the top of my head, if you want to share a TLS connection you're obviously fucked, if you use gRPC you need to specify an env flag to be fork safe, memory overhead that interacts poorly with reference counted GC, etc.

Again, in this example I suspect things would have worked, because it's trivial code, but I wouldn't actually bet on it because I've seen MP fuck up so many times historically. Like, maybe one of those modules actually creates a static connection pool that gets messed up on mp? Who knows?

So yeah, maybe the obscene hack that 'mp' is would have worked or just use tcl, which is sane and worked for them. A note about mp in the post would have made sense, I just won't blame someone for not wanting to deal with it.

Re:Tcl is faster than Python for database benchmarking by bb88 on Tuesday November 01, 2022 @08:38PM (#33429954)
> if you want to share a TLS connection you're obviously fucked...

Some would argue that if you're using threads, well then you're fucked from the start, very possibly including me.

Go gets around this using go-routines, but go isn't necessarily thread safe per se. Futher go also has it's own bag of bugs you have to be aware of when using it.