Hey everyone,
I know this topic is a little bit old but we have recently created a plugin that would help reducing the post meta queries involving _bbp_last_active_time. The plugin is righthere.
We basically move the meta to his own table for reading which reduce considerably the query time. The good thing about this plugin is that it is non intrusive meaning once bbpress core find a solution to resolve this issue, one can only deactivate the plugin and everything will be back to normal.
Any feedback welcomed!
Cheers!