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

[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