Performance verifying for Sqlite in-memory mode.
Performance verifying for Sqlite in-memory mode.
Testing environment:
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