Performance verifying for Sqlite in-memory mode.

最新推荐文章于 2024-01-11 23:36:18 发布

MU_SZ

最新推荐文章于 2024-01-11 23:36:18 发布

阅读量1.7k

点赞数

分类专栏：技术杂谈

本文链接：https://blog.csdn.net/my_business/article/details/8633666

版权

9 篇文章 0 订阅

订阅专栏

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

关注