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

[Aaron Bockover <abockover novell com>]

I need to follow up here to apologize for implying that our package
maintainer was deficient in packaging a more recent version of sqlite3
in openSUSE 11.1.

I had installed the Android SDK which was in my PATH. Apparently the SDK
ships the 3.5.9 version of sqlite3, and that's what I ended up using for
doing this test. The version in openSUSE 11.1 is 3.6.4, quite
acceptable.

--Aaron

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