Documentation: WAL journal mode is faster

[presidento]

According to my measurements, the WAL journal mode has even better performance than batch update with autocommit=False. If you agree, it can be mentioned in the documentation...

[mpenkov]

Can you show some benchmarks with sqlitedict code?

[presidento]

I can point out the related parts of the linked code.

Bechmark parts:

• write
• batch write
• read
• combined

They are executed against many persitent dict implementation. The SqliteDict related parts:

• autocommit=True
• autocommit=False
• autocommit=True, journal_mode="WAL"

The result of the benchmarks are on the linked comment.