SQLite 和 LiteDB 性能对比

数据库 码拜 5年前 (2019-05-15) 19155次浏览 0个评论

LiteDB是一个小型的.NET平台开源的NoSQL类型的轻量级文件数据库。特点是小和快,dll文件只有200K大小,而且支持LINQ和命令行操作,数据库是一个单一文件,类似Sqlite

SQLite 是一个轻型的数据库,实现了自给自足的、无服务器的、零配置的、事务性的 SQL 数据库引擎。SQLite 是在世界上最广泛部署的 SQL 数据库引擎。SQLite 源代码不受版权限制。

简单操作对比 SQLite 和 LiteDB 性能

对比结果:

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

时间越短表示性能越好

LiteDB

  • #1 Default 默认
  • #2 Encrypted 加密
  • #3 Exclusive mode and no journal 独占模式 无日志

SQLite

  • #1 Default 默认
  • #2 Encrypted 加密
  • #3 No journal 无日志

测试环境 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

源码地址:https://github.com/mbdavid/LiteDB-Perf


CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明SQLite 和 LiteDB 性能对比
喜欢 (5)
[1034331897@qq.com]
分享 (0)

文章评论已关闭!