Smart Groups Slow To Load

[mbales]

I'm running 8.43 on a Lion server (that only runs JSS and SUS) and when I attempt to view a smart group in JSS it takes 5+ minutes if it loads at all. Any ideas on how to remedy this? The group in question only contains 9 machines.

[jarednichols]

how big is your DB?

[Matt]

I have the same issues. I made a smart group yesterday and its still slowly updating today.

[mbales]

Roughly 20gbs.

[Cyberghost · Accepted solution]

I had the same prob. DB Size 33 GB. Now with 2GB the JSS is much fast. Is it possible to activate "Flush Policy Logs"?

[mbales]

I'll try flushing the logs over night and report back.

[mbales]

Deleted a number of the older logs and now the JSS is running very smoothly and is quick to return smart groups and other data. Thanks for your help as always.

[NTmatter]

Sorry to revive a dead thread, but I've found that you can add an extra index to the usage_logs table. I think this needs to be recreated every time the JSS is restarted, but it seems to do the trick every time I need to query a smart group:

CREATE INDEX `computer_mtime` ON `usage_logs` (`computer_id`,`date_entered`);

This does have the tradeoff that inserting new data may be somewhat slower, but it beats being unable to query smart group membership :)