Pagerfanta / Double Query

[StefanGlaesser]

Hello,
I'm using the Pagerfanta component for navigation through my results page by page:

$userPaginator = $finder->findPaginated($request->get('q'));
$userPaginator->setCurrentPage($page);

That leads to 2 (nearly identical) elasticsearch queries:

1. query: {"query":{"query_string":{"query":"ak"}}}
2. query: {"query":{"query_string":{"query":"ak"}},"from":10,"size":10}

So my question is, why are 2 queries fired instead of one?

[rudrud]

+1 same issue

[jmcclell]

👍 Same here.

[merk]

The double query is being caused by the pagination adaptor. Someone can have a go at fixing it if they'd like to but I expect this problem to disappear with the new paginator approach that will eventually be written then merged.

[merk]

This one cant be easily fixed without revamping the entire pagination process - if getTotal or getFacets is called before getElasticaResults() in the RawPaginationAdapter, 2 queries must be issued because we dont know the offset/size to query.

[jmcclell]

So if we ensure that we call getElasticaResults() first the problem shouldn't appear?

[merk]

It cant be guaranteed. You dont know the offset or size when calling getTotalHits().