Comment 6 for bug 1286944

I just tried getting noise 0.3.1+r1909+pkg95~daily~ubuntu0.4.1 to scan my 24 GB music collection, and it has also slowed to a crawl, currently a bit below the 8 GB mark. Two things I've noticed:

1. I can hear disk activity each time it says it has scanned another song. It would probably help to batch the inserts into transactions (e.g. only commit the changes every N seconds, or every N files during the scan).

2. When I checked the schema of the sqlite3 database, there were no indexes. I'm guessing there is a SELECT query being done before inserting each file that results in a full table scan. This would be consistent with the process slowing down as the database gets larger. If you can add an index that can be used by this query (or queries), it will likely make a huge performance improvement.

The second option is probably the easiest one to fix to get rid of the slow down. The first would probably only make a noticeable difference after fixing the second.