This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:update_indexes:home [2011/06/29 23:02] admin |
dev:sql:statements:update_indexes:home [2012/10/26 15:00] (current) |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| ==== WIth Options ==== | ==== WIth Options ==== | ||
| - | === MAX_THREADS === | + | === MAX_THREADS - Setting the number of processors used for indexing === |
| MAX_THREADS=thread_count allows the setting of the maximum number of processors to be used during the update index process. | MAX_THREADS=thread_count allows the setting of the maximum number of processors to be used during the update index process. | ||
| Line 50: | Line 50: | ||
| UPDATE INDEXES WITH LOG=odxlogs; | UPDATE INDEXES WITH LOG=odxlogs; | ||
| - | UPDATE INDEXES WITH LOG=c:\mydatabase/log | + | UPDATE INDEXES WITH LOG=c:\mydatabase\log |
| - | === BUF === | + | === BUF - Setting the amount of indexing memory === |
| BUF=mega_bytes is used to increase the internal size of indexing buffers used by the Omnidex indexing operation. | BUF=mega_bytes is used to increase the internal size of indexing buffers used by the Omnidex indexing operation. | ||
| Line 66: | Line 66: | ||
| > update indexes with log=odxlogs; | > update indexes with log=odxlogs; | ||
| > setenv oa_max_rows | > setenv oa_max_rows | ||
| - | > update indexes with log=odxlogs; | ||
| > exit | > exit | ||
| os> | os> | ||