The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
What does the table INDEXUPDATES do?
Posted: 10 Sep 09 11:04 AM
|
Greetings,
Can anyone tell me the purpose of the INDEXUPDATES table? I've been looking at the general size of our DB as it's hitting 20Gb now, and I've noticed that the table with the most rows is INDEXUPDATES, with 2,402,193 records. Can these be purged? The earliest records are from 2005... |
|
|
|
Re: What does the table INDEXUPDATES do?
Posted: 10 Sep 09 12:07 PM
|
Speedsearch....
So, unless you are using it, you could try the following:
- Disable the Speedsarch triggers:
UPDATE SLXTRIGGERS SET ENABLED = 'F' WHERE PATH = 'SLXSEARCHTRIGGER.DLL'
- Remove the data
TRUNCATE TABLE INDEXUPDATES
|
|
|
| |
|
Re: What does the table INDEXUPDATES do?
Posted: 11 Sep 09 3:30 AM
|
| Interesting. SS is running, as I can do searches and stuff, but the table is still huge. I guess that leaves the "configured or running correctly" problem. |
|
|
|
Re: What does the table INDEXUPDATES do?
Posted: 12 Sep 09 11:23 AM
|
| Use the Administrator to schedule/run incremental updates on the Speedsearch indexes. I believe the incremental update process uses the entries in the INDEXUPDATES table to know what updates are needed and then removes the entries. |
|
|
|