maximum Data that can be stored in single String array property in aem 6.5 Node | Community
Skip to main content
srinivas_chann1
srinivas_chann1
Level 7
September 20, 2022

maximum Data that can be stored in single String array property in aem 6.5 Node

  • September 20, 2022
  • 2 replies
  • 1320 views

Hello,

 

I would need to store a query search results node paths in a single string [] property in a node, so that I could use this latter for a cronjob

 

Wanted to know if the query results had about 5000  search results can the single string [] property hold so much value of node path

 

Is there any limit or threshold for a single string [] property after which it may break.

 

Please provide inputs

 

 

Regards,

Srinivas

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity Advisor
Community Advisor
September 20, 2022

Not sure about how long for the cron job to read it. But there is no limitation though in setting it. Wont it better option to create an xml or json with search results and put it in DAM and the cron job reads it? 

Similar question answered here by Adobe fellows

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/is-there-a-limitation-to-the-size-of-jcr-property-value/m-p/215572 

    joerghoh
    Adobe Employee
    joerghohAdobe Employee
    Adobe Employee
    September 20, 2022

    You will get the first warnings when you hit 100k in the property. I would recommend to stay below that limit.

     

    if you assume that you get into that range or even higher, store the data as nt:file node.

     

     

      srinivas_chann1
      srinivas_chann1Author
      Level 7
      September 21, 2022

      @joerghoh  Thanks for the input. 

       

      1>100k is the length of string size it can hold or it is array size ??

      2>Any sample code to store data as nt:file and also to read the data from nt:file will be helpful

       

      Regards,

      Srinivas

        joerghoh
        Adobe Employee
        joerghohAdobe Employee
        Adobe Employee
        September 24, 2022

        The spec does not mention any limits, but of course the implementation makes some assumptions about sizes; exceeding them can cause memory problems or make your system slow. That means that if you know that the size of the data you want to store can exceed 100k or more, I recommend to store it in a binary node directly.

         

        Here's an example how to write binary content into an nt:file: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/writing-files-to-the-jcr-using-a-sling-servlet/m-p/121396

         

        You might also be interested in https://cqdump.joerghoh.de/2022/07/05/whats-the-maximum-size-of-a-node-in-jcr-aem/

         

         

         

        Terms & ConditionsAccessibility statement

        Loading footer...