Comment 4 for bug 2073787

Revision history for this message
Benjamin Drung (bdrung) wrote (last edit ): Re: apport-retrace needs more than 1 GB

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.