|
#1
|
|||
|
|||
Version 4.1
Released on October 13, 2009
Enhancements Ultra Recall 4.1 can utilize SQLite's full-text search (FTS) capabilities for improved phrase searching. In UR 4.0 and earlier, UR stored keywords for all text that was parsed from item text and documents. Since the keywords are indexed, "contains keyword" and Quick searches are typically very fast. But since individual words, not the full text, are stored in the database file, phrase searching could be slow (since the item text needs to be reparsed during the search), and displaying the Item Text and Item Notes attributes could also be slow. To use the new FTS capability, backup your database, then choose Tools | Compact and Repair on the menu, check the Enable enhanced full-text search features checkbox (also check Compact to shrink the database as much as possible after converting), and click OK. The conversion process can take a while, since each item must be reparsed for its text, and linked online documents must be retrieved again for their text content. Converting a 250 MB database took about 20 minutes in our tests. Converting a database to use FTS actually shrank the database by 20% on average, but your results may vary. New databases have FTS enabled by default, but existing databases are not automatically converted to enable FTS (the existing search behavior is used). Databases that have been converted to use FTS can also be converted back to the old behavior (by unchecking the Enable option in Compact and Repair). When FTS is enabled, the bottom of Help | About | Install Info will show Database version: 4.0.0 [FTS], the Auto-generated keywords list in the Keywords dialog (Item | Keywords) will always be empty, Tools | Keyword Exclusions is disabled (no longer applies), and an item's Keyword Count attribute will include only user-defined keywords. Searches work nearly the same as with FTS disabled (implicit AND when multiple words are entered in the search criteria, OR supported for 'or' conditions, double quotes for phrase searches, etc.), but extended phrase searching syntax is no longer necessary, and phrase searches should be faster. New capabilities include the NOT prefix to exclude items containing a specific word, NEAR to find two words near each other, and parentheses are supported for complex search conditions. A Relevance system attribute is also available in the Search Results pane (View | Choose Columns). Differences to be aware of: Bug Fixes + = Professional edition only |
|
|