Performance verifying for Sqlite in-memory mode.

发布时间：2020-12-12 20:20:30 所属栏目：百科来源：网络整理

导读：Performance verifyingfor Sqlite in-memory mode. Testing environment: Key-Value Map List table(100 fields) test case bytes * times Insert Query once a record and ( 50 * 100 )bytes every record times Insert Query 100K bytes =bytes * times 10

Key-Value MapList table(100 fields)
test casebytes * timesInsertQueryonce a record and ( 50 * 100 )bytes every record
timesInsert
Query
100K bytes =bytes * times
10bytes * 10K 1.154s1.825s1K
0.187s 6.240s 100bytes * 1K 0.109s 0.219s 100 0.015s 0.656s 1K * 100 0.000s 0.016s 10 0.063s 10K * 10 5 0.031s 1M bytes=bytes * times
10bytes * 100K 10.218s18.736s3 0.016s 100bytes * 10K 1.123s2.028s10.000s 1K * 1K 0.266s 10K * 100 0.046s 100K * 10 1K bytes * times
1K * 10 0.031s 0.140s 0.281s 1K * 10K 1.108s2.013s 1K * 100K 11.637s11.482s10K bytes * times
0.000s
10K * 1K 0.188s 0.296s 10K * 10K 1.622s2.745s100K bytes * times
100K * 100 0.078s 100K * 1K 0.499s 0.936s 100K * 10K 5.788s9.391s1M bytes * times
1M * 10 1M * 100 0.422s 0.280s 1M * 1K 3.744s2.746s10M bytes * times
10M * 10 0.312s 10M * 100 4.649s3.198s100M bytes * times
100M * 1 0.577s 100M * 10 3.292s

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Performance verifyingfor Sqlite in-memory mode.

Testing environment: