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

[amrhassan <amr hassan gmail com>]

Thanks for trying to help, but that didn't really make any noticeable
difference. Banshee is still jittery and its cpu usage still spikes to 100%
every time i hit "next" or browse through my humongous library.


Bertrand Lorentz wrote:
> 
> 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/ <
> 
>  
> _______________________________________________
> banshee-list mailing list
> banshee-list gnome org
> http://mail.gnome.org/mailman/listinfo/banshee-list
> 
> 

-- 
View this message in context: http://www.nabble.com/Can-i-use-MySql-for-a-database--tp21176384p21178495.html
Sent from the Banshee mailing list archive at Nabble.com.