Performance verifying for Sqlite in-memory mode.

前端之家收集整理的这篇文章主要介绍了Performance verifying for Sqlite in-memory mode.前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

Performance verifyingfor sqlite in-memory mode.@H_301_2@

Testing environment:@H_301_2@

Key-Value Map@H_301_2@@H_404_18@ @H_404_18@ @H_301_2@@H_404_18@ List table(100 fields)@H_301_2@
@H_404_18@
@H_404_18@
test case@H_301_2@@H_404_18@ bytes * times@H_301_2@@H_404_18@ Insert@H_301_2@@H_404_18@ Query@H_301_2@@H_404_18@ once a record and ( 50 * 100 )bytes every record@H_301_2@
@H_404_18@
times@H_301_2@@H_404_18@ Insert@H_301_2@
@H_404_18@
Query@H_301_2@
@H_404_18@
100K bytes =bytes * times@H_301_2@
@H_404_18@
10bytes * 10K@H_404_18@ 1.154s@H_404_18@ 1.825s@H_404_18@ 1K@H_301_2@
@H_404_18@
0.187s@H_404_18@ 6.240s@H_404_18@
100bytes * 1K@H_404_18@ 0.109s@H_404_18@ 0.219s@H_404_18@ 100@H_301_2@@H_404_18@ 0.015s@H_404_18@ 0.656s@H_404_18@
1K * 100@H_404_18@ 0.000s@H_404_18@ 0.016s@H_404_18@ 10@H_301_2@@H_404_18@ 0.063s@H_404_18@
10K * 10@H_404_18@ 5@H_301_2@@H_404_18@ 0.031s@H_404_18@
1M bytes=bytes * times@H_301_2@
@H_404_18@
10bytes * 100K@H_404_18@ 10.218s@H_404_18@ 18.736s@H_404_18@ 3@H_301_2@@H_404_18@ 0.016s@H_404_18@
100bytes * 10K@H_404_18@ 1.123s@H_404_18@ 2.028s@H_404_18@ 1@H_301_2@@H_404_18@ 0.000s@H_404_18@
1K * 1K@H_404_18@ 0.266s@H_404_18@ 10K * 100@H_404_18@ 0.046s@H_404_18@ 100K * 10@H_404_18@ 1K bytes * times@H_301_2@
@H_404_18@
1K * 10@H_404_18@ 0.031s@H_404_18@ 0.140s@H_404_18@ 0.281s@H_404_18@ 1K * 10K@H_404_18@ 1.108s@H_404_18@ 2.013s@H_404_18@ 1K * 100K@H_404_18@ 11.637s@H_404_18@ 11.482s@H_404_18@ 10K bytes * times@H_301_2@
@H_404_18@
0.000s@H_404_18@
@H_404_18@
10K * 1K@H_404_18@ 0.188s@H_404_18@ 0.296s@H_404_18@ 10K * 10K@H_404_18@ 1.622s@H_404_18@ 2.745s@H_404_18@ 100K bytes * times@H_301_2@
@H_404_18@
100K * 100@H_404_18@ 0.078s@H_404_18@ 100K * 1K@H_404_18@ 0.499s@H_404_18@ 0.936s@H_404_18@ 100K * 10K@H_404_18@ 5.788s@H_404_18@ 9.391s@H_404_18@ 1M bytes * times@H_301_2@
@H_404_18@
1M * 10@H_404_18@ 1M * 100@H_404_18@ 0.422s@H_404_18@ 0.280s@H_404_18@ 1M * 1K@H_404_18@ 3.744s@H_404_18@ 2.746s@H_404_18@ 10M bytes * times@H_301_2@
@H_404_18@
10M * 10@H_404_18@ 0.312s@H_404_18@ 10M * 100@H_404_18@ 4.649s@H_404_18@ 3.198s@H_404_18@ 100M bytes * times@H_301_2@
@H_404_18@
100M * 1@H_404_18@ 0.577s@H_404_18@ 100M * 10@H_404_18@ 3.292s@H_404_18@

猜你在找的Sqlite相关文章