JCR query performance | AEM Community Blog Seeding

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,204 likes

Total Posts

6,402 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,204 likes

Total Posts

6,402 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

17-09-2020

BlogImage.jpg

JCR query performance by Cognifide Tech Blog Posts

Abstract

The way JCR queries are constructed has dramatic impact on their performance. This article is about writing queries that won’t kill the AEM instance.
What are JCR queries?
AEM stores data in Jackrabbit Oak, a Java Content Repository (JCR) implementation. JCR queries allow searching the repository and retrieving selected nodes.

There are three query languages supported and one of them is JCR-SQL2. It is similar to SQL used in relative database management systems and - similarly to SQL - it is easy to write a query that is time and resource consuming. However, it is often possible to rewrite a query to make it much faster.

Read Full Blog

JCR query performance

Q&A

Please use this thread to ask the related questions.