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