TurboDB VCL/CLX Component Library
Creating a Full-text Index at Design-time See also |
Previous Top Next |
1. | Open TurboDB Viewer. Usually it can be found in your Tools menu. The application is located in the bin subdirectory of your TurboDB installation folder.
|
|
2. | Open the table you want to create the full-text index for using the command DataSet/Open/Table...
|
|
3. | Open the full-text index wizard with Table/Full-text Index...
|
|
4. | On the first page select a name for the new helper table that will accept the keywords. Then enter a name for the keyword column within this table. The third item is the maximum length of the keywords. Keyword longer than this value will be cut.
|
|
5. | On the second page you can choose wich columns in the original table will be scanned. You may add all columns to the full-text index but very often you will add only a few fields.
|
|
6. | Since searching for words like and, in or a in a full-text index does not make much sense, you should try to eliminate those keywords form the full-text index. You can do this in two ways. First, you may decide to throw away keywords, which occur more often than a given limit, e.g. 100. Second, you can provide a text file that contains the words you don't want to be added to the full-text index. Both techniques will help to keep the full-text index small, will speed up searching and will avoid useless hits. The appropriate settings are done on the third page of the wizard.
|
|
7. | On the forth page of the wizard you are ready to create the full-text index. Since this action involves scanning all fields of all records in the table, it might take quite a time until completion.
|