Skip to main content

Does dspCompose have a limit to the number of records that can be processed?

Answered

Comments

3 comments

  • Best answer
    DSP Expert

    CBermingham: There is not a setting to limit the number of records per request in dspCompose. The practical limit will vary between templates, based on the number of fields and validations and the strength of the server. You could add config and validation to your templates to enforce a policy-driven limit by template.

    0
  • DSP Expert

    TEmpson: The number of records for the Excel import is configured under Admin > Configuration > Parameters >  Page Parameters. 100,000 is a good balance for normal use. If you have a powerful server, you can explore with more. When importing Excel via Collects, there is a commit size (normally 10,000) to keep down memory usage. I do not think that same option is available under the Excel Integration, which is another reason for using 100,000.

    0
  • DSP Expert

    JWoods: Hi Pasquale. In my experience, dspCompose does struggle with timeouts on validations with any large record sets, particularly from the built-in config option for listbox validations (with medium to large field groupings). I agree with Chris that you should definitely add config and validation to enforce record limits.

    0

Please sign in to leave a comment.