Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Index in AEM6.2

Avatar

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
umamaheswariy65
Level 2

28-08-2017

Hi Team,

  I am seeing a lot of slow queries in my AEM 6.2 author instance lately.   We did in-place migration from aem5.6.1 to AEM6.2.

Most of them are related to the evnt Jobs /jcr:root/var/eventing/jobs//element(*,slingevent:Job)[@event.job.topic = 'com/day/cq/replication/job/publish1' and not(@slingevent:finishedState)] order by @slingevent:created ascending.

How Can I create an index in oak for these or what is the best way to improve this? 

Thanks In Advance.

Replies

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,128 likes

Total Posts

6,133 posts

Correct Reply

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

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,128 likes

Total Posts

6,133 posts

Correct Reply

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

28-08-2017

Jörg Hoh​ Any help here?

~kautuk

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

29-08-2017

Hi,

please get in touch with Adobe AEM support and request a set of optimized index definitions (and how to apply them safely), which will help in this case.

Jörg

Avatar

Avatar
Validate 1
Level 3
poojac35931336
Level 3

Likes

20 likes

Total Posts

50 posts

Correct Reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
poojac35931336
Level 3

Likes

20 likes

Total Posts

50 posts

Correct Reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
poojac35931336
Level 3

29-08-2017

Please go through this link of adobe seminar. It has very good points on optimizing the query and index

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

29-08-2017

Forgot to mention: I point to support, because it is a known issue and there is already a solution available for it. And as the query is being caused by the product itself, you cannot change the query itself.

Jörg

Avatar

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
umamaheswariy65
Level 2

29-08-2017

Hi Jorg, what is the solution and where can I find that solution?

Thanks In Advance

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,087 likes

Total Posts

3,121 posts

Correct Reply

1,063 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

29-08-2017

As said, please contact support!

Jörg

Avatar

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
umamaheswariy65
Level 2

Likes

11 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
umamaheswariy65
Level 2

29-08-2017

Hi Jorg,

I got it. I will open a ticket with support.

Thanks:)