Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Needs Review
Workspace Domino Designer
Created by Guest
Created on Feb 19, 2021

DQL / QueryProcessor : add a Count / Limit parameter to get only the first n result and optimise performance

Currently we get all the result in the executeToJSon or forthcoming view.


Sometimes we only need the first results of a complex query and sorting operation.


Returning only a subset of the result would help parsing / navigating view performance.


As an addition/alternative, maybe start / count parameter would help performance and also paging for UI elements


  • Attach files
  • Guest
    Reply
    |
    Sep 9, 2022

    The topic needs more thought and design. Certainly a limit is not hard to specify coming in, but given sort order and things like aggregation, it might have very little effect on performance.

  • Guest
    Reply
    |
    Feb 19, 2021

    if you only get a aubset of the possible results, how can you be sure that this subset contains the relevant data?


    And what about aggregation? It would not work with a subset only.