Re: [sqlite] Optimizing Songbird

Richard and Scott - big thanks for the suggestions. -Mike - Original Message - From: "Scott Hess" To: "General Discussion of SQLite Database" Sent: Monday, August 2, 2010 1:45:26 PM Subject: Re: [sqlite] Optimizing Songbird [Sorry for the

Re: [sqlite] Optimizing Songbird

accessing the database. Thanks again, Mike - Original Message - From: "Mike Hays" <mi...@songbirdnest.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Friday, July 30, 2010 2:25:27 PM Subject: Re: [sqlite] Optimizing Songbird Hi R

Re: [sqlite] Optimizing Songbird

- Original Message - From: "Richard Hipp" <d...@sqlite.org> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Friday, July 30, 2010 1:11:02 PM Subject: Re: [sqlite] Optimizing Songbird On Fri, Jul 30, 2010 at 3:26 PM, Mike Hays <m

[sqlite] Optimizing Songbird

Hi sqlite-users, I'm working on improving the SQLite database performance for Songbird, an open-source media player based on Firefox/Mozilla. We're seeing pretty poor performance with large media libraries - ideally we'd like to support 100,000 media items and maintain reasonable performance.