- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 10:26 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 12:43 PM
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"?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 10:58 AM
how big is your DB?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 11:12 AM
I have the same issues. I made a smart group yesterday and its still slowly updating today.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 11:26 AM
Roughly 20gbs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 12:43 PM
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"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-14-2012 04:03 PM
I'll try flushing the logs over night and report back.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-15-2012 08:32 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 10-29-2012 01:26 AM
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 :)
