Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.

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

Avatar

Level 8

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

4 Replies

Avatar

Community Advisor

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

Avatar

Employee Advisor

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.

 

 

Avatar

Level 8

@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

Avatar

Employee Advisor

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/