Skip to content

numberOfResults causing performance issue with PaginationNavigator #173

Open
@spry-rproud

Description

@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.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions