Re: [Banshee-List] Can i use MySql for a database?



On Fri, 2008-12-26 at 10:38 -0800, amrhassan wrote:
> emmm. No. I'm just using it regularly after installing the deb from the
> team's ppa repository. I've got over 14K tracks in my library and it's been
> causing me a lot of trouble on amarok with sqlite too, but mysql really
> solved all my performance issues. My mysqld is already running so why not
> use it!

You might want to try running the following command from a terminal :

sqlite3 ~/.config/banshee-1/banshee.db "ANALYZE"

It tells sqlite to analyze the content of the database, so that it makes
better use of the indexes.
I've seen big performance improvements after this, in some cases.
I filed a bug about this :
http://bugzilla.gnome.org/show_bug.cgi?id=555937

-- 
Bertrand Lorentz <bertrand lorentz gmail com>
> http://flickr.com/photos/bl8/ <

Attachment: signature.asc
Description: This is a digitally signed message part



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]