The query on the forums frontpage is really slow, maybe someone has a clue on how to fix it ?:
12213 ms select dbqd.forums.lib.forums.forums-chunk.select_forums: select nsdb0
select forums_forums_enabled.*,
(select count(*)
from forums_messages_approved
where forums_messages_approved.forum_id = forums_forums_enabled.forum_id
and parent_id is null) as n_threads,
to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
case when last_post > (now() - interval '1 day') then 't' else 'f' end as new_p
from forums_forums_enabled
where forums_forums_enabled.package_id = '3061'
and (
forums_forums_enabled.posting_policy = 'open'
or forums_forums_enabled.posting_policy = 'moderated'
or 't' = acs_permission__permission_p(forums_forums_enabled.forum_id, '7797','forum_read')
)
order by forums_forums_enabled.nam