Awesome

LiteDB-Perf

A simple actions to compare SQLite and LiteDB v3

Results:

5.000 records	LiteDB #1	LiteDB #2	LiteDB #3	SQLite #1	SQLite #2	SQLite #3
Insert	4.999 ms	5.690 ms	4.839 ms	46.379 ms	49.296 ms	4.107 ms
Bulk	236 ms	280 ms	219 ms	122 ms	122 ms	106 ms
Update	3.674 ms	3.784 ms	3.242 ms	47.470 ms	48.490 ms	4.101 ms
CreateIndex	176 ms	174 ms	176 ms	13 ms	36 ms	8 ms
Query	204 ms	208 ms	93 ms	457 ms	463 ms	468 ms
Delete	157 ms	207 ms	140 ms	11 ms	13 ms	3 ms
Drop	17 ms	56 ms	14 ms	11 ms	25 ms	3 ms
FileLength	7.580 kb	7.576 kb	7.572 kb	3.824 kb	3.856 kb	3.824 kb

Low is better

LiteDB

#1 Default
#2 Encrypted
#3 Exclusive mode and no journal

SQLite

#1 Default
#2 Encrypted
#3 No journal

Tested on MacBook Pro 2012 i5, Win10, 8Gb RAM, SSD


LiteDB: default - 5000 records
==============================
Insert         :  4999 ms -     1000 records/second
Bulk           :   236 ms -    21184 records/second
Update         :  3674 ms -     1361 records/second
CreateIndex    :   176 ms -    28321 records/second
Query          :   204 ms -    24467 records/second
Delete         :   157 ms -    31722 records/second
Drop           :    17 ms -   289513 records/second
FileLength     :  7580 kb

LiteDB: encrypted - 5000 records
================================
Insert         :  5690 ms -      879 records/second
Bulk           :   280 ms -    17820 records/second
Update         :  3784 ms -     1321 records/second
CreateIndex    :   174 ms -    28669 records/second
Query          :   208 ms -    24037 records/second
Delete         :   207 ms -    24078 records/second
Drop           :    56 ms -    87898 records/second
FileLength     :  7576 kb

LiteDB: exclusive no journal - 5000 records
===========================================
Insert         :  4839 ms -     1033 records/second
Bulk           :   219 ms -    22775 records/second
Update         :  3242 ms -     1542 records/second
CreateIndex    :   176 ms -    28379 records/second
Query          :    93 ms -    53243 records/second
Delete         :   140 ms -    35574 records/second
Drop           :    14 ms -   334283 records/second
FileLength     :  7572 kb

SQLite: default - 5000 records
==============================
Insert         : 46379 ms -      108 records/second
Bulk           :   122 ms -    40827 records/second
Update         : 47470 ms -      105 records/second
CreateIndex    :    13 ms -   367266 records/second
Query          :   457 ms -    10933 records/second
Delete         :    11 ms -   441583 records/second
Drop           :    11 ms -   454141 records/second
FileLength     :  3824 kb

SQLite: encrypted - 5000 records
================================
Insert         : 49296 ms -      101 records/second
Bulk           :   122 ms -    40851 records/second
Update         : 48490 ms -      103 records/second
CreateIndex    :    36 ms -   136413 records/second
Query          :   463 ms -    10798 records/second
Delete         :    13 ms -   357189 records/second
Drop           :    25 ms -   199642 records/second
FileLength     :  3856 kb

SQLite: no journal - 5000 records
=================================
Insert         :  4107 ms -     1217 records/second
Bulk           :   106 ms -    47121 records/second
Update         :  4101 ms -     1219 records/second
CreateIndex    :     8 ms -   592916 records/second
Query          :   468 ms -    10680 records/second
Delete         :     3 ms -  1578981 records/second
Drop           :     3 ms -  1574952 records/second
FileLength     :  3824 kb