[MTOS-dev] Query syntax for generic use?

[OtherNiceMan]

Fumiaki

The big problem I can see is performance, looking at the generated SQL
code I see all the search terms surrounded by wildcards (%term%). This
means that no optimisation can be performed by the SQL engine such as
using indexes. So you are reading every word in the specified columns
for the entire blog. I think though that this is more a general issue
with mt-search rather than the fact you are adding lucerne syntax.

2008/4/4 Fumiaki Yoshimatsu <fyoshimatsu at sixapart.com>:
> I have been thinking about how/why to move the parser of Lucene syntax
> to somewhere for more generic use in MT.
> I updated the Wiki document [1].  I am looking for ideas and suggestions
> about how the query syntax can be used.
>
> [1] http://wiki.movabletype.org/Proposal:GenericUseOfSearchQuery
>
> I am leaning towards leaving the parser in search at least for now,
> because I could not come up with a good reason why you want to use the
> syntax in plugins and templates, when it can be done in other ways
> currently.
>
> Thanks for the suggestion in advance!
>
> Fumiaki Yoshimatsu
> Movable Type Engineering,
> Six Apart K.K.
>
> _______________________________________________
> MTOS-dev mailing list
> MTOS-dev at sixapart.com
> http://www.sixapart.com/mailman/listinfo/mtos-dev
>



-- 
Rob 'The Other Nice Man' Kenny
Have Dice, Will Travel