Bug 244432

The SearchRequest Class should expose the values from CategoryResult.MAX_RESULTS and/or *.ALL_MAX_RESULTS to optimize queries for the SearchProvider.

Sometimes it would be useful to know the real search result limits to prepare queries (e.g. database select optimizations, like the FIRST or ROWS clause, JDBC-setFetchSize, ...).

Example:

public class PersonNameSearch implements SearchProvider {

  @Override
  public void evaluate(SearchRequest request, SearchResponse response) {
        
    String req = request.getText();
    int limit = request.getResultLimit(); // proposal

    ...

    PreparedStatement stmt = ...

    stmt.setFetchSize (limit);