From: PCMan <pcm...@gm...> - 2010-04-05 14:52:14
|
OK, To solve the previously addressed problems, I add a new branch sqlite to experiment with new idea.s This time I directly access the medialib file of xmms2 with sqlite3, and fonud it's much faster. So the problem is quite apparantly caused by poor IPC roundtrip design. However, the sqlite database is not in good format, either. So the query became very slow. With this sqlite branch, it gets reasonable speed while doesn't require additional caching mechanism or additional library. (sqlite3 is already required by xmms2) I know that it's better fixed in upstream server code, but from the git log of their code, the new database format code is not updated for quite a long time and we don't know when will xmms2 has next new release. So, let's use our own hacks for now before they fix it. Please test and give some opinions. |