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@
| |