Finder-Integration/Finder — Issue #62: FinderIndexerAdapter Optimization - Double Cost
Author: anibalsanchez
Created: 2012-02-11 15:27:29+00:00
State: open

I've checking getListQuery-getItems and getListQuery-getContentCount in FinderIndexerAdapter.

The SQL query is executed two times. One to count the items and the second to retrieve the rows.

If CMS has N articles, every Index execution has 2*N cost. This doubles the execution time.

As an optimization, in the long term, It's going to be better to use the same query to count and retrieve the items.

Regards,
Anibal