Implement full-text search
In the old search on Name you could search on substring. Example Name = 'Tryton',
you could search for 'yto' and Tryton would be in the search result. In the new
search this is not the case.
Activity
On 18/10/11 00:09 +0200, Okko wrote:
>
> Okko <ohuisman@cloudsuite.com> added the comment:
>
> maybe you are correct with 'yto' but for example name = 'Cloud Suite' I think (and
> Google) search string 'Sui' should return a result. In the current Search it is
> not.
This is not acheivable correctly with a SQL database.OpenBravo is still using the unnatural/previous way. I feel using % is not
what a standard user will understand.
If Tryton does not want to change it, I think we will have to customize it
to the unnatural way for our customers.
On Mon, Oct 17, 2011 at 11:52 PM, Cédric Krier <issue_tracker@tryton.org>wrote:
>
> Cédric Krier <cedric.krier@b2ck.com> added the comment:
>
> It was the previous behavior which was unnatural.
> I don't know any search engine that search as Tryton does previously.
>
> ----------
> status: chatting -> invalid
>
> _______________________________________________
> Tryton issue tracker <issue_tracker@tryton.org>
> <https://bugs.tryton.org/#2204>
> _______________________________________________
>The main problem with substring search is that it force the database to do a
full scan on the related table while matching only at the beginning of the
string allows the database to use the index (if one exist). So it can became
quite slow on big databases.
The job of matching any substring is done by full-text search engines, so if
there is a feature request for this issue, it should be implementing a full-text
support in Tryton.On 18/10/11 23:41 +0200, Bertrand Chenal wrote:
> The job of matching any substring is done by full-text search engines, so if
> there is a feature request for this issue, it should be implementing a full-text
> support in Tryton.
And I think xapian [1] could do the job. I will try to analyse how roundup use
it.
[1] http://xapian.org/
