Performance verifying for Sqlite in-memory mode

Performance verifying for Sqlite in-memory mode.

Performance verifying for Sqlite in-memory mode.

Testing environment:

Key-Value Map    List table(100 fields)
    test casebytes * timesInsertQuery once a record and ( 50 * 100 )bytes every record
timesInsert 
Query 
100K bytes = bytes * times 
10bytes * 10K1.154s1.825s  1K 
0.187s6.240s 100bytes * 1K0.109s0.219s  1000.015s0.656s  1K * 1000.000s0.016s  100.000s0.063s 10K * 100.000s0.000s  50.000s 0.031s1M bytes = bytes * times 
10bytes * 100K10.218s18.736s  30.000s 0.016s 100bytes * 10K1.123s2.028s  10.000s 0.000s  1K * 1K0.109s0.266s      10K * 1000.016s0.046s      100K * 100.000s0.000s     1K bytes * times 
1K * 100.000s0.000s      1K * 1000.000s0.031s      1K * 1K0.140s0.281s      1K * 10K1.108s2.013s      1K * 100K11.637s11.482s     10K bytes * times 
10K * 100.000s0.000s     
10K * 1000.015s0.016s      10K * 1K0.188s0.296s      10K * 10K1.622s2.745s     100K bytes * times 
100K * 100.000s0.015s     
100K * 1000.078s0.140s      100K * 1K0.499s0.936s      100K * 10K5.788s9.391s     1M bytes * times 
1M * 100.031s0.031s     
1M * 1000.422s0.280s      1M * 1K3.744s2.746s     10M bytes * times 
10M * 100.499s0.312s     
10M * 1004.649s3.198s     100M bytes * times 
100M * 10.577s0.312s     
100M * 104.649s3.292s     

查看更多 下一篇