by brainier » Tue Apr 21, 2009 1:57 pm
So it does - an I have other examples of words that do not appear when searched for, so I thought I would do a little research. If I search for "lord" or "lords" I get 41 results on my copy of the database. Searching for "jesus" gives 863 results.
I opened the database in Turbo DB Viewer (search Google for this) and updated the full-text index (in viewer I opened MainTable, Table menu > Create full-text index). One of the questions asked during this process was what is the upper limit for keywords that occur too often. The Turbo DB Viewer set this to 1000 (note that this is greater than the 863 for "jesus"). I set this value to 9999 and build a new full-text index. I reopened Zionworx and now searched for "lord". I got 1286 results. I suspect that Zionworx has the same upper limit and this ought to be increased in the next update of the product - say maybe 2 or 3 thousand. There cannot be many words that turn up that often, but given that the database product does not index them rather than returning a "too many" error is not consistent with general users experience of search engines. It ought, but it would seem to be outside the scope of the database engine used, to say "here is 1000 results for 'lord', please redefine your query".
To finish my test, I rebuilt the index and stopped at 500 repeated words. This time a search for "jesus" found 1 result - a song with the word "jesus-" in it! So, a recommendation and a workaround.
Recommendation: Increase the search frequency count in the full-text index to a few thousand or add this to the .ini file to allow different churches to decided on own what they want (as increasing beyond current values might slow the indexing down on very large song databases with slow computers)
Workaround: Download Turbo DB Viewer and build your own index and not use the index updater in Zionworx. Zionworx comes with a file called KeywordExclude.txt which should be used during the index generation program (and of course check that this file does not contain the word "lord" as well).