datalevin 2024-09-22

Hello everyone! Such a question: when I use inside the with-transaction body one "big" transact! , is it better for performance then many small transact!s? How big is difference?

within a with-transaction, all txs are committed in a single LMDB tx, so it doesn't make a big difference in this aspect, however, there's overhead in turning a catalog tx into LMDB one, so in general, bigger tx is preferred

👍 1

Good! Thank you for rapid answer