[question] what is the point of max-per-tx

[KamelittaOida]

Since the speed seems to remain constant, I'm struggling to understand the utility of this flag --max-per-tx= Thank you so much for this tool.

keywords: what is the point of --max-per-tx=1000 what is the point of max-per-tx=1000 what is the point of --max-per-tx crazyymaxx merge firefox history firefox merge places.sqlite

[SophieFitz]

@KamelittaOida It's got to do with Sqlite and checkpointing. So tx is transaction, or checkpoint in Sqlite terminology. Crazymax has configured it so that you can change how many items get moved from the .wal file into the actual DB per checkpoint. I've made my own history combiner program and I've set the autocheckpoint (equivalent of what crazymax calls max-per-tx) to 1 instead of 1000. I found I ran into errors otherwise.

So it's more of a consistency thing, rather than a speed thing.

[KamelittaOida]

I see. thanks for answering me. And for plugging the/a continuation of the project.

[SophieFitz]

No worries, well if you're curious, here's the link: Firefox History Combiner. It's my own thing, independent of crazymax's project.

[KamelittaOida]

thanks. I've already had clicked your username. but thanks