[MTOS-dev] Query syntax for generic use?

[Timothy Appnel]

On Fri, Apr 4, 2008 at 3:23 AM, OtherNiceMan <otherniceman at gmail.com> wrote:

>  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.

I believe you are right on all counts. You raise a very good concern
about performance, but I don't think its necessarily related to the
Lucene parser itself.

Still I think shipping the Lucene parser is a good thing in that in
that its promotes its use over home spun solutions like has been the
case up until now.

<tim/>

-- 
Timothy Appnel
Appnel Solutions
http://appnel.com/