numberOfResults causing performance issue with PaginationNavigator

[spry-rproud]

paginatedQuery is slowed down quite a bit by the query used to populate numberOfResults. The current query generated is :

select '1' from Foo where (...)

With large tables this query is quite slow and would be improved with:

select count(1) from Foo where (...)

This will require counting support in Activate.