Re: [Tracker] Ontology: add indexes for nie:mimeType and nfo:fileName

[Ralph Böhme <rb netafp com>]

Thanks for pushing!

-Ralph

Am 05.06.2014 um 11:20 schrieb Martyn Russell <martyn lanedo com>:

> On 04/06/14 16:33, Ralph Böhme wrote:
> > Hi Martyn
>
> Hi Ralph,
>
> Thanks for CCing the list, I was going to write an email and then I noticed.
>
> > in case you want to incorporate this upstream, here are the ontology changes you crafted yesterday.
> >
> >     Ontology: add indexes for nie:mimeType and nfo:fileName
> >
> >     Enable indexing for "nie:mimeType" and "nfo:fileName", both are
> >     attributes that will be used in queries generated by Netatalk and
> >     Samba.
> >
> > <https://github.com/slowfranklin/tracker/commit/5111f7a9bbf0186b3b8375adcabf58853cce381d>
> >
> > Patch:
> > <https://github.com/slowfranklin/tracker/commit/5111f7a9bbf0186b3b8375adcabf58853cce381d.patch>
>
> I've pushed this now to master. I don't know yet if it will make it into 1.0.3.
>
>
> For everyone else
> -----------------
> This change makes sense in a lot of ways, fileName is quite useful for queries and I believe tracker-needle 
> uses it, so it will improve performance there. But the biggest gain is with mimeType which makes even more 
> sense to index because we have functions like:
>
>  tracker-control --reindex-mime-type
>
> Which will work faster with mime based lookup.
>
>
> About upgrading
> ---------------
> The superb code that Philip and Jürg wrote for the ontology upgrade handling means that this will work 
> without any data loss.
>
> One thing to note is that those with larger data sets might see some initial delay while tracker-store 
> re-creates the indexes. I watched this happen for Ralph's dataset which has a *database* in the order of 10 
> gigabytes or so (IIRC) and it took about 10-15 minutes.
>
> Shutting down tracker-store can also take a few minutes with datasets of this size. Please be patient to 
> avoid any data loss.
>
> Thanks,
>
> > Sorry, forgot to add kudos for you. :)
>
> Happy to help ;)
>
> -- 
> Regards,
> Martyn
>
> Founder & Director @ Lanedo GmbH.
> http://www.linkedin.com/in/martynrussell

-- 
Ralph Böhme <rb netafp com>
Netatalk Developer | Support | Services
NetAFP joins SerNet: <http://www.netafp.com/sernet-expands-apple-support-netatalk-and-samba-merge-1230/>