On 2016-07-15 09:47, Chetan Mehrotra wrote:
In most cases where code uses JcrUtils.putFile [1] it leads to creation of below content structure+ foo.jpg (nt:file) + jcr:content (nt:resource) - jcr:data Due to usage of nt:resource each nt:file node creates a entry in uuid index as nt:resource is referenceable [2]. So if a system has 1M nt:file nodes then we would have 1M entries in /oak:index/uuid as in most cases the files are created via [1] and hence all such files are referenceable ...
Another thing we could is to reduce the overhead of indexing the UUIDs in the first place. At least for MongoDB and RDBs we could easily let the underlying persistence layer do it for us.
Best regards, Julian
