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

[Aaron Bockover <aaron bockover gmail com>]

Honestly, those symptoms don't sound related to sqlite/your library. If
all you are doing is clicking "next", nothing much happens DB wise...

What does "sqlite3 --version" say?

Could you also run this:

banshee-1 --debug --debug-sql &> banshee-sql-log

And play around with Banshee for a couple of minutes? It would then be
helpful if you could open a bug with the details from this mailing list
thread, and attach the log above (banshee-sql-log), mention your
hardware and sqlite version.

If you don't mind uploading a compressed version of your database
somewhere, that could prove extremely helpful in finding the real cause
of the slow down, or at least ruling out sqlite. I've done tests on
databases in many cases 2 or 3 times as large with no slow down. 

Thanks,
Aaron


On Fri, 2008-12-26 at 12:44 -0800, amrhassan wrote:
> That's a shame. I thought I could wait a while for someone to implement this.
> I also thought that all dbs work the same way and mono provides a really
> good layer of db abstraction so any type could be used easily.
> 
> Anyway, I'm using a 3.0GHz P4 processor with HT, 1GB of ram and 2GB of swap
> memory on Ubuntu 8.10 and i'm using the sqlite version that came with the
> deb package. I haven't changed anything. Banshee is very jittery and it
> often spikes to 100% cpu usage even with no interaction of me. Like right
> now when i'm playing my library on shuffle.
> 
> My library db file is about 30 something MB, do you want me to upload it
> somewhere for you?
> 
> I recently moved to banshee as Amarok 2 looks very ugly on gnome and I
> thought that banshee looks very promising and it integrates well with gnome.
> 
> 
> Aaron Bockover wrote:
> > 
> > On Fri, 2008-12-26 at 19:58 +0100, LCID Fire wrote:
> > 
> >> > No, that is not currently supported.
> >> A general question - if mysql support would be submitted would it be
> >> accepted into main repro?
> > 
> > Not likely, not likely at all. Our database layer is very specific to
> > sqlite for things like indexes, caches, and various optimizations.
> > 
> > http://svn.gnome.org/svn/banshee/trunk/banshee/src/Libraries/Hyena/Hyena.Data.Sqlite/
> > 
> > .. and various other things.
> > 
> > I'd be more interested in getting a copy of this 14k track library,
> > hardware information, and the sqlite version.
> > 
> > --Aaron
> > 
> >> _______________________________________________
> >> banshee-list mailing list
> >> banshee-list gnome org
> >> http://mail.gnome.org/mailman/listinfo/banshee-list
> > 
> > _______________________________________________
> > banshee-list mailing list
> > banshee-list gnome org
> > http://mail.gnome.org/mailman/listinfo/banshee-list
> > 
> > 
>