RE: [Koha-devel] [Bug 363] Searching on contains works only with full names.
Spoken like a true computer geek ... I'm sorry, but just because it's hard on the computer doesn't mean that someone isn't going to want to do it. Admittedly, our db isn't that big, but "partial" means partial, it does not mean "starts with". Two suggestions - either add it as an option, warning that it will need to scan the entire index and hence is likely to be slow, or create an index that progressively strips leading characters. To speed a brute force search up, you could possibly create a file that consists solely of the words, so you can search that file for matches, and then look up the match in the index itself. Actually - a third option too - create a "flipped word" index so you can do an "ends with" search. Cheers, Wol -----Original Message----- From: bugzilla-daemon@wilbur.katipo.co.nz [mailto:bugzilla-daemon@wilbur.katipo.co.nz] Sent: 24 April 2003 15:47 To: koha-devel@lists.sourceforge.net Subject: [Koha-devel] [Bug 363] Searching on contains works only with full names. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=363 paul.poulain@free.fr changed: What |Removed |Added ------------------------------------------------------------------------ ---- Status|NEW |RESOLVED Resolution| |REMIND ------- Additional Comments From paul.poulain@free.fr 2003-04-25 02:46 ------- it's not a bug, it's a feature. I can easily add a search on the beginning of the word. It's a very bad idea to add a like %word%, performance would be really poor... so, do we keep "full word only" search or do "starting word" ? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
Anthony W Youngman wrote:
Spoken like a true computer geek ...
True, but we are on koha-devel, and bugzilla :-) So it's supposed to be only for geek. (or future geeks !)
I'm sorry, but just because it's hard on the computer doesn't mean that someone isn't going to want to do it.
I don't say it's hard on the computer. I say performance would be really poor... really.
Admittedly, our db isn't that big, but "partial" means partial, it does not mean "starts with".
Yes, but on a 200 000 biblio DB...
Two suggestions - either add it as an option, warning that it will need to scan the entire index and hence is likely to be slow, or create an index that progressively strips leading characters. To speed a brute force search up, you could possibly create a file that consists solely of the words, so you can search that file for matches, and then look up the match in the index itself. Actually - a third option too - create a "flipped word" index so you can do an "ends with" search.
the word index already exists. So you can search very fast any biblio having title containing "tower", thus findind 'the two towers'. The question was to find the two towers when entering only "tow". That's possible too, but i'm not sure it's an interesting feature. What is impossible is to find "the two towers" when searching "owe". And i think it's a good feature ! when you enter owe, you search "owe", not "tower". -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (2)
-
Anthony W Youngman -
paul POULAIN