Hi,
I am not very clear with your question,
If question is on performance of fetching such pages via Query builder API then the performance depends on type of query and amount of data to be searched.
I recommend using JCR API to query the AEM JCR. However -- you can also use the QueryBuilder API. This API is a wrapper of the JCR API. Using either API -- you can query for a result set and then process the result set and place the data in a report.
Or use Xpath acs-aem-samples/SampleQueryBuilder.java at master · Adobe-Consulting-Services/acs-aem-samples · GitH...
Reference good reads:- http://aempodcast.com/2015/aem-resources/aem-queries-xpath-jcr-sql2-query-builder-syntaxes/#.WlXeBkq...
and
I hope this would be of some help to you.
Thanks and Regards
Kautuk Sahni
Kautuk Sahni