Poehali ... or how to use FastTextSearch
FastTextSearch package contains EMPLOYEE.GDB database, where CUSTOMER, CONTACT_FIRST, CONTACT_LAST, ADDRESS_LINE1, ADDRESS_LINE2, CITY, COUNTRY fields are indexed in the CUSTOMER table.
The query allows to select all customer, which title contains lexical items "tech" or "corp" in this fields:
Some remark: FastTextSearch/IB breaks up all string and text memo into words, and build index which contain this word. Searching for index is realized on coinciding beginning of word with sample. Hereupon, records, contain word "incorporated", will not be found at searching for word "corp".
Second sample query:
This query selects all customer title or name containing elements "hong" and "kong" in indexed fields:
FastTextSearch/IB also works in SoundEX search mode:
Select all customer title/name with SoundEX containing lexical elements equal to SoundEX("jon"):
Quick and fast ... or analysis of performance.
Brought diagrams show that only indexed access to data is used!