use table partition to increase inserting performance
when the number of data excess 5 million. mysql database will face a significant drop down in inserting speed. (From 50,000 data per second to 50,000 data per minutes xD) So we can
Writing112
Fix memory error caused by memory overflowing
When I was adding all my song to the data base yesterday, I always found memory error after several song was processed. after checking the task manager, i found i got memory overfl
Improving sqlalchemy inserting performance for large set of data
in these four way, the speed core > bulk_insert_mappings > bulk_save_objects >>>>> add() add is slower than others for almost 10 times Just not use add when inserting large amount
Electron packaging
Two method, electron-builder or electron-packager install npm isntall -g electron-packager and npm isntall -g electron-builder Use electron packager:electron-packager <sourcedir> <
Solution to mplayer playing voice and picture out of sync
when i was playing with mplayer in my ras pi. I found that it always appear warning "Your system is too slow to play this". And voice often play faster than the video. after some m
raspberry pi using vnc, can't log in.
Last night, when i was using vnc to log in my ras pi, i found that i stuck in the login menu. which means even i type the correct password, after several sec, it going back to the
Fininshing Update Shazam analysis(chinese version)
See First section-Bilibili Second section-Bilibili Third section-Bilibili
Shazam听歌识曲算法解析+python实现-3 检索歌曲
第三部份在开始之前，我们首先要认真阅读一下论文《An Industrial-Strength Audio Search Algorithm》。 paper下载链接：https://www.ee.columbia.edu/~dpwe/papers/Wang03-shazam.pdf中文翻译：https://blog.csdn.net/yutianzuijin/
shazam听歌识曲算法解析+python实现-2 生成指纹
第二部份在开始之前，我们首先要认真阅读一下论文《An Industrial-Strength Audio Search Algorithm》，最好是一个字一个字，一个图一个图的把paper看下来（然后你就不需要来看这篇文章了，笑） paper下载链接：https://www.ee.columbia.edu/~dpwe/papers/Wang03-shazam
shazam听歌识曲算法的解析与听歌识曲python实现的分析-1 读取歌曲
###shazam听歌识曲算法的解析与听歌识曲python实现的分析-1 读取歌曲开新坑，歌曲识别计划。使用的算法是《An Industrial-Strength Audio Search Algorithm》，其中部分代码借鉴了Github的dejavu项目。关于读取歌曲，首先需要安装一个python库. pydub。你可以使用pip3 install p