When executing the following query, the response time of the API is very slow (30+ second response time).

select revisions from dir / where (comment matches 'SIX' or p4:jobid =~ '(^|[^a-zA-Z0-9-])SIX-[0-9]+($|[^a-zA-Z0-9-])') and date > 2010-04-12T22:41:32Z order by date group by changeset return csid

This query is being used by JIRA/Fisheye Plugin to display the "Source" tab on a Project.