in reply to Re^4: fast simple DB (sqlite?) skeleton?
in thread fast simple DB (sqlite?) skeleton?

Using the original key generation logic, which produces hardly any key collisions, I get the following results:

s/iter preprocess original preprocess 4.30 -- -4% original 4.11 5% --

Replies are listed 'Best First'.
Re^6: fast simple DB (sqlite?) skeleton?
by pmqs (Friar) on Jan 29, 2010 at 10:11 UTC
    That is hardly surprising - the test harness is carrying out more db writes plus the extra cost of preprocessing that it will never use.

    We would need to know more about the input data (like the % of key colisions) to take this any further.