This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:creation:updating [2012/01/30 16:54] doc |
admin:indexing:creation:updating [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| ====== Administration: Omnidex Indexing ====== | ====== Administration: Omnidex Indexing ====== | ||
| - | ===== Indexing Creation ===== | + | ===== Index Creation ===== |
| [[admin:indexing:creation:home|Overview]] | | [[admin:indexing:creation:home|Overview]] | | ||
| Line 11: | Line 11: | ||
| [[admin:indexing:creation:files|Index Files]] | | [[admin:indexing:creation:files|Index Files]] | | ||
| [[admin:indexing:creation:performance|Performance]] | [[admin:indexing:creation:performance|Performance]] | ||
| + | ---- | ||
| ==== Updating Indexes ==== | ==== Updating Indexes ==== | ||
| Line 50: | Line 50: | ||
| <code> | <code> | ||
| - | > update indexes for index STATE_CITY_ZIP | + | > update indexes for index HOUSEHOLDS.STATE_CITY_ZIP; |
| Database | Database | ||
| Table Rows CPU Elapsed | Table Rows CPU Elapsed | ||
| ---------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | ||
| SIMPLE | SIMPLE | ||
| - | HOUSEHOLDS 1,909 0:00 0:00 | + | HOUSEHOLDS 1,909 0:00 0:03 |
| - | INDIVIDUALS 5,000 0:00 0:00 | + | |
| ---------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | ||
| - | Total 0:00 0:03 | + | Total 0:00 0:04 |
| - | Omnidex indexes updated | + | Index (HOUSEHOLDS)HOUSEHOLDS.STATE_CITY_ZIP updated |
| > | > | ||
| </code> | </code> | ||
| - | |||
| - | |||
| - | |||
| - | |||
| ==== ==== | ==== ==== | ||