[启动性能优化] sqlite批量insert测试 about shigureader HOT 8 CLOSED

参考batchInsert() 超级快

[batchInsert] file_table 52724 2068ms
[batchInsert] tag_table 113603 1820ms

from shigureader.

不知道从sqlite迁移到mysql，性能会提升多少

from shigureader.

优化后的insertion表现

//时间秒/文件数
console.log("hdd without insertion")
console.log(1.139/1903*10000)
console.log(1.306/1903*10000)
console.log(1.184/1903*10000)


console.log("hdd")
console.log(1.184/1903*10000)
console.log(1.155/1903*10000)
console.log(1.124/1903*10000)


console.log("ssd")
console.log(1.586/2490*10000)
console.log(1.598/2490*10000)
console.log(1.525/2490*10000)

结论：scan的时候，固态和普通硬盘无差别
大约1000个文件，需要6.1秒

from shigureader.

优化后的insertion表现

无insertion
[chokidar] 1.699s scan complete. 2785
[chokidar] 1.847s scan complete. 2785
[chokidar] 1.769s scan complete. 2785

有insertion
[chokidar] 2.161s scan complete. 2785
[chokidar] 2.064s scan complete. 2785
[chokidar] 2.149s scan complete. 2785

from shigureader.

https://www.sqlite.org/speed.html

from shigureader.

https://www.cnblogs.com/hchxxzx/archive/2011/10/17/2215797.html
https://blog.csdn.net/talkingmute/article/details/104089049

from shigureader.

from shigureader.

原来sort性能比_.sortBy强好多啊

https://www.measurethat.net/Benchmarks/Show/14335/0/sortby-vs-js-sort

from shigureader.