Re: full-text search : How to improve ?

Hi Norbert:

In message <[email protected]>,
SCHLEMMER Norbert writes:
>Merry Christmas!

Same to you.

>Steps to reproduce this behaviour :
>
>.) create new issue with title "TMCS Version 8.806.17 @Vmware / tvmRel81Srv16A"
>.) add a change note "tvmRel81Srv16A.tmcsOne.pdts.at"
>
>.) create new issue with title "TMCS Version 8.806.17 @Vmware / tvmRel81Srv19A"
>.) add a change note "tvmRel81Srv19A.tmcsOne.pdts.at"
>
>.) search with 'All text' filter on "tvmRel81Srv19A" give you both issues
>
>.) search with 'All text' filter on "tvmRel81Srv16A" give you both issues
>
>Comment: tvmRel81Srv16A and tvmRel81Srv19A are host names of our test
>environment
>
>expected behaviour : 
>search with 'All text' filter on "tvmRel81Srv16A" shall just found the
>issue respective tvmRel81Srv16A
>
>search with 'All text' filter on "tvmRel81Srv19A" shall just found the
>issue respective tvmRel81Srv19A

I get the expected behavior. See it at:

 https://rouilj.dynamic-dns.net/demo/issue (user demo, password demo)

 https://rouilj.dynamic-dns.net/demo/issue?@search_text=tvmRel81Srv16A

According to the about page
(https://rouilj.dynamic-dns.net/demo/?@template=about) I am using
xapian for full text search. The about page is documented at
https://wiki.roundup-tracker.org/AddAboutPage.

Can you add the about page to your tracker. Follow the directions in
the wiki and ask here if you have issues. I am not sure the wiki
directions have been tested.

Once it is installed, verify that you are using the native indexer.

If you are using the native indexer we can look further into how to
debug this. I'll have to check how that works with mysql (that is the
database you use right??). AFAIK we aren't using native full text
searching for the rdbms backends. It's a word lookup table with an
index to a second table and the second table has all the info needed
to look up the item. So this can't be some wierd stemming/fuzzy search
issue IIUC.

Also how big is your database?

Have a great rest of your weekend.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.