Creating a database with only jammy-proposed (fits into memory):
* pickle: 43s for creation, 5s for querying (including pickling)
* SQLite: 45s for creation, 1s for querying
* DBM (GNU): 123s for creation, 1s for querying
* DBM (NDBM): 208s for creation, 1-2s for querying
Creating a database with jammy (does not fit into memory):
* pickle: 4h37m29s for creation, 18m50s for load and a single dict access (test_retrace_jammy_sandbox took 16075.58s = 4.5h)
* SQLite: 14m19s for creation, 1.6s for querying
* DBM (GNU): manually aborted after 10h
* DBM (NDBM): manually aborted after several hours (did not check the clock)
So DBM is disqualified and SQLite is the only remaining contender.
Benchmark results on a Raspberry Pi Zero 2W:
Creating a database with only jammy-proposed (fits into memory):
* pickle: 43s for creation, 5s for querying (including pickling)
* SQLite: 45s for creation, 1s for querying
* DBM (GNU): 123s for creation, 1s for querying
* DBM (NDBM): 208s for creation, 1-2s for querying
Creating a database with jammy (does not fit into memory):
* pickle: 4h37m29s for creation, 18m50s for load and a single dict access (test_retrace_ jammy_sandbox took 16075.58s = 4.5h)
* SQLite: 14m19s for creation, 1.6s for querying
* DBM (GNU): manually aborted after 10h
* DBM (NDBM): manually aborted after several hours (did not check the clock)
So DBM is disqualified and SQLite is the only remaining contender.