5 ms·
re: 32bit land, You should look into MDB_VL32 in mdb.master as other posters have suggested. If any single commit takes multiple seconds, you've probably writt
by hyc_symas 8y ago
re: 32bit land, You should look into MDB_VL32 in mdb.master as other posters have suggested.
If any single commit takes multiple seconds, you've probably written too much data in a single transaction. Above about 512MB it starts preemptively flushing intermediate pages out, to keep the in-RAM footprint limited. Some of those intermediate pages will need to be read back in if your transactions are hitting all over the DB. This is where the main slowdown comes.