how big is your DB?

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

Roughly 20gbs.

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"?

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

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.

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 :)