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

[srinivas_chann1]

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

[Saravanan_Dharmaraj]

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-t... 

[Jörg_Hoh]

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]

@Jörg_Hoh  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

[Jörg_Hoh]

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-u...

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