Performance verifying for 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 | 10bytes * 10K | 1.154s | 1.825s | 1K | 0.187s | 6.240s | ||
| 100bytes * 1K | 0.109s | 0.219s | 100 | 0.015s | 0.656s | |||
| 1K * 100 | 0.000s | 0.016s | 10 | 0.000s | 0.063s | |||
| 10K * 10 | 0.000s | 0.000s | 5 | 0.000s | 0.031s | |||
| 1M bytes = bytes * times | 10bytes * 100K | 10.218s | 18.736s | 3 | 0.000s | 0.016s | ||
| 100bytes * 10K | 1.123s | 2.028s | 1 | 0.000s | 0.000s | |||
| 1K * 1K | 0.109s | 0.266s | ||||||
| 10K * 100 | 0.016s | 0.046s | ||||||
| 100K * 10 | 0.000s | 0.000s | ||||||
| 1K bytes * times | 1K * 10 | 0.000s | 0.000s | |||||
| 1K * 100 | 0.000s | 0.031s | ||||||
| 1K * 1K | 0.140s | 0.281s | ||||||
| 1K * 10K | 1.108s | 2.013s | ||||||
| 1K * 100K | 11.637s | 11.482s | ||||||
| 10K bytes * times | 10K * 10 | 0.000s | 0.000s | |||||
| 10K * 100 | 0.015s | 0.016s | ||||||
| 10K * 1K | 0.188s | 0.296s | ||||||
| 10K * 10K | 1.622s | 2.745s | ||||||
| 100K bytes * times | 100K * 10 | 0.000s | 0.015s | |||||
| 100K * 100 | 0.078s | 0.140s | ||||||
| 100K * 1K | 0.499s | 0.936s | ||||||
| 100K * 10K | 5.788s | 9.391s | ||||||
| 1M bytes * times | 1M * 10 | 0.031s | 0.031s | |||||
| 1M * 100 | 0.422s | 0.280s | ||||||
| 1M * 1K | 3.744s | 2.746s | ||||||
| 10M bytes * times | 10M * 10 | 0.499s | 0.312s | |||||
| 10M * 100 | 4.649s | 3.198s | ||||||
| 100M bytes * times | 100M * 1 | 0.577s | 0.312s | |||||
| 100M * 10 | 4.649s | 3.292s |