This topic has 1 reply, 2 voices, and was last updated 6 years ago by JnRouvignac.

  • Author
    Posts
  • #12023

    Hi Ludo,

    Could you please suggest the optimal index entry limit that I can have for corporate data (~300,000 to 500,000). Does it depends on total data or the data returned in search filter?

    e.g. Can I modify the entry limit say up to 200,000 for some attribute in filter if COUNT is 133,310 in order to avoid [NOT-INDEXED] or [LIMIT-EXCEEDED] search? or It is better to perform non indexed search instead.

    Could you please suggest or share a link where I can read more for optimal values for Index-Entry-Limit.

    Thanks,
    Saurabh Chaturvedi

    #12038
     JnRouvignac
    Participant

    Hi Saurabh,

    See the chapter Changing Index Entry Limits in the Admin Guide.
    I strongly recommend to be very cautious when changing this value and only do it after careful analysis.
    The bigger the index-entry-limits, the more data will be loaded and written to disk on single updates to the DB (add, delete, modify) which can be quite expensive.

    For a more complete view, you may look at Ludo’s post:
    https://ludopoitou.com/2011/07/28/opendj-analyzing-search-filters-and-indexes/

    Jean-Noel

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?