Huge insert

By huge we mean 10 000 000+. Below you will find table that shows how
much it take to insert next 100 000 data. On the right side you
will find a hundreds of hundreds of thousands (so 195 means 19.5
milions) data that are already in database. Whole test was to insert 40 000 000 records. Test was performed with only HashIndex enabled.

Surprised?

As you can see while Kyoto Cabinet is quite fast in most cases, it slowdowns a lot sometimes (do you know better setup that we should use? Contact us). autosync and autotran was disabled in Kyoto Cabinet. What's even more important in CodernityDB you can have more than one index (it affects performance though), so you don't have to copy your data all over single databases.

There you will find statistics for that tests:

Database

Min

Max

Mean

Std

Total

Kyoto Cabinet

0.629998922348

146.798651934

13.6441506329

25.5503667156

5471.30440378

CodernityDB

1.63907909393

12.9895970821

4.57873315585

4.57873315585

1836.0719955

CodernityDB slow downs on when there is a lot of records in database, but as you can see it performs pretty stable. And remember, Kyoto Cabinet is C++ database while CodernityDB is pure Python.