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

[Aaron Bockover <abockover novell com>]

Just out of curiosity, I wanted to try a simple test with SQLite. On
openSUSE 11.1, sqlite3 is at version 3.5.9. I installed 3.6.7 from
source into a private prefix and ran the following test against both
versions:

(for ((i=0;i<100;i++)); do (time $SQLITE ~/.config/banshee-1/banshee.db
'select * from CoreTracks' 1>/dev/null) 2>&1 | awk
'/^real/{sub(/^real[0-9\t]+m/,""); sub(/s$/,""); print}'; done;) | awk
'{sum = sum + $0; } END { print sum / NR }'

SYSTEM SQLITE (3.5.9)
=====================
export SQLITE=sqlite3
0.14098 (average time to select all columns from 5120 rows)

PRIVATE SQLITE (3.6.7)
======================
export SQLITE=./sqlite3
0.11208 (average time to select all columns from 5120 rows)

Nice to see a good deal of gain here, but I'm fairly pissed that the
sqlite3 in 11.1 is from May 2008.

--Aaron



On Fri, 2008-12-26 at 16:05 -0500, Aaron Bockover wrote:
> 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
> > > 
> > > 
> > 
> 
> _______________________________________________
> banshee-list mailing list
> banshee-list gnome org
> http://mail.gnome.org/mailman/listinfo/banshee-list