Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, August 7, 2020 
 
slxdeveloper.com Community Forums  
   
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!
 External Development Forums - Design & Architecture Topics
Forum to discuss designing applications to work with SalesLogix. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Design & Architecture Topics | New ThreadView:  Search:  
 Author  Thread: What does the table INDEXUPDATES do?
Mark Hanford
Posts: 131
 
What does the table INDEXUPDATES do?Your last visit to this thread was on 1/1/1970 12:00:00 AM
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...
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: What does the table INDEXUPDATES do?Your last visit to this thread was on 1/1/1970 12:00:00 AM
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

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: What does the table INDEXUPDATES do?Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 11 Sep 09 2:34 AM
Definitely truncate it as per Raul's instructions. These updates are ordinarily consumed by SpeedSearch but if SS isn't confiigured or running properly - they just end up in this table and build up.

Some other tips : http://www.empath-e.com/Support/resources.asp#SlowPerf

[Reply][Quote]
Mark Hanford
Posts: 131
 
Re: What does the table INDEXUPDATES do?Your last visit to this thread was on 1/1/1970 12:00:00 AM
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.
[Reply][Quote]
Doug Evenhouse
Posts: 66
 
Re: What does the table INDEXUPDATES do?Your last visit to this thread was on 1/1/1970 12:00:00 AM
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.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2020 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 8/7/2020 7:47:10 PM