Hi, Mathieu Othacehe <[email protected]> skribis:
>> Isn’t that the real problem, that we’re doing one transaction per >> derivation? > > Is it really better in term of performance to send batch of queries > within a single transaction? I haven't tried it yet. I’m definitely not a database expert, but I think there’s overhead for setting up a transaction, which we’re paying N times here. > I think that the real bottleneck was having N fibers fighting over 4 > workers to execute large number of insertions. Having all those queries > done by workers dedicated to registration in a single pass seems to > improve a lot the situation. Then that’s great, let’s profit! :-) Ludo’.
