Comment 11 for bug 485966

Can we tile it in little parts.
I would like to have exclusion on its own :)

2010/3/2 Mikkel Kamstrup Erlandsen <email address hidden>

> Let's revive this old bug, and get the code in a mergeable state. Would
> be a nice feature for 0.3.3.
>
> I still think we should limit *-queries to prefix queries only. Without
> a full text index queries with * inter*sper*sed in the strings will
> require a full table scan and expensive string checking. With a log of
> 1M events this will *completely* take down a regular netbook for several
> minutes.
>
> This will diminish the syntax to be ! as prefix and * as suffix and
> should simplify the code a bit... Prefix queries can use the index on
> the textual columns (at least they do so in most db systems i know).
>
> I am not saying that full text querying is not useful - quite the
> contrary. I am saying that if we want to support full text querying then
> we should do it properly.
>
> --
> Using filters (text match / exclusion / etc)
> https://bugs.launchpad.net/bugs/485966
> You received this bug notification because you are subscribed to The
> Zeitgeist Project.
>
> Status in Zeitgeist Framework: In Progress
> Status in Zeitgeist Framework 0.3 series: In Progress
>
> Bug description:
> - How can I get all events except those with interpretation VISIT_EVENT?
>
> - In case you give me above the awful answer "looking for all
> interpretations except VISIT_EVENT", how can I get all events except those
> from application "firefox.desktop"?
>
> - How can I get all those events whose URI ends with "myfile.txt"?
>
> - And those events whose title contains "zeitgeist"?
>
>
>
>