My Introduction: A DB guy (GN)

[GN]

Switched to simple text on my Gmail editor, lets see if this fixes the
formating fiasco of my last reply.

Adding my comments below.

Cheers,
G

> Message: 7
> Date: Wed, 08 Sep 2010 20:56:15 +0200
> From: Ralf Engels <ralf-engels at gmx.de>
> Subject: Re: My Introduction: A DB guy (GN)
> To: amarok-devel at kde.org
> Message-ID: <1283972175.17274.21.camel at pc02>
> Content-Type: text/plain; charset="UTF-8"
>
> On Mi, 2010-09-08 at 12:00 +0200, amarok-devel-request at kde.org wrote:
> >
> > logging out while amarok was playing) the statistics, dynamic playlist
> > and a
> > bunch of other tables would be outdated. I'll try to catch up with
> > what's
> > going on first and then contribute to the best of my abilities.
>
> Hi,
> I am currently reworking the collection scanner, the scan processor and
> a lot of things around it.
>
> I didn't need to change any tables but I suspect that access to the
> tracks and urls table could be optimized. I can provide some data if you
> need.
> You can see the code that creates the tables in
> src/core-impl/collection/sqlcollection/DatabaseUpdater.cpp

Thanks for the pointer. I still have to set up my dev environment and
I'll be out of town next week, but this is a good point for me get
started. Thank you for highlighting it.

> Also you might want to have a look at my current state here:
> http://gitorious.org/~rengels/amarok/rengelss-amarok/commits/collectionscanner

Will certainly do.

> I plan to wait until 2.3.2 is before commiting. The changes were quite
> extensive (but good. I discovered a lot of small bugs and
> inconsistencies).

> Ralf

Nice to meet you, my IRC handle (or twitter for that matter) is 'seattlegaucho'.