Hi > 1) Flushing after every folder is scanned sounds like it could have a > significant impact on scanning performance. Using your friend's large > collection have you noticed any reduction in scanning speed? I tested it with my small collection and is has a huge impact. The explanation is also fairly easy. Because sqlite force a write to the HD on commit with some consistency checks you can only do ~50 commits/s on an average HD. This writing to the hd is visible when the scanner seems to stall on one title.
Reading the sqlitedb shouldn't be affected by the scanner as sqlite allows for multiply reads all the time, also with an open transaction. > 2) RE: returning in BSTM if the table query fails I think this looks like a > nice workaround to that bug. It results in bad behavior because the table > will still contain the old contents while the sidebar reflects the new view > but it's much better than the alternative (assertion failures). Is there actually a reliable way to reproduce this error. I sometimes get it at random and so far I failed to reproduce it with ways that other described. As far as I understand the sqlite specs the db should never block to a read request, so I'm puzzled why this happens in mixxx. The pause button is a good idea though. Most users probably won't notice that canceled scan will commit every songs it added so far and that they can just resume by restarting the library scanner. best, Max ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Get Mixxx, the #1 Free MP3 DJ Mixing software Today http://mixxx.org Mixxx-devel mailing list Mixxx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mixxx-devel