Styjun

Possibility to correct pitch from digital versions of records with the hole not centered

Alice's First Code Review

When moving a unique_ptr into a lambda, why is it not possible to call reset?

Ways to demonstrate ("show-off") contributions as an undergraduate in research

How can I review my manager, who is fine?

Diagram with cylinder shapes and rectangles

Can we share mixing jug/beaker for developer, fixer and stop bath?

Can you create a free-floating MASYU puzzle?

Did William Shakespeare hide things in his writings?

Is it ok for parents to kiss and romance with each other while their 2- to 8-year-old child watches?

Sorting a list according to some pre-specified rules

What does the multimeter dial do internally?

When is one 'Ready' to make Original Contributions to Mathematics?

Why did Robert F. Kennedy loathe Lyndon B. Johnson?

I don't want to be introduced as a "Minority Novelist"

As a supervisor, what feedback would you expect from a PhD who quits?

Intern not wearing safety equipment; how could I have handled this differently?

Why did the frequency of the word "черт" (devil) in books increase by a few times since the October Revolution?

How to deal with account scam and fraud?

What is the shape of the upper boundary of water hitting a screen?

How does the cloaker's Phantasms action work?

Attach a visible light telescope to the outside of the ISS

What are the consequences for a developed nation to not accept any refugee?

My professor has told me he will be the corresponding author. Will it hurt my future career?

Spring data mongodb collect distinct subcollections - Performance Tuning

Retrieve only the queried element in an object array in MongoDB collectionMongoDB: Combine data from multiple collections into one..how?What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?Slow MongoDB lookup aggregation on very few and very small documentsSpring data mongoDb not null annotation like Spring data JpaSpecifing a Sharded Collection with Spring Data MongoDBperformance issue on Spring Data MongodbSpring Data MongoDB reactive distinct not workingSpring Data MongoDB Slow MongoTemplate.find() Performance

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

[
 
 "categories":
 "category":[
 "sub1",
 "sub2",
 "sub3"
 ],
 "category2":[
 "sub1",
 "sub2"
 ]
 
 ,
 
 "categories":
 "category":[
 "sub1",
 "sub4"
 ],
 "category2":[
 "sub5",
 "sub4"
 ]
 
 
]

want to get the distinct category and category2 using Spring data. I have tried both Aggregation and Distinct both slow on performance i hope i am missing something

Aggregation:

AggregationResults<Category> results = mongoTemplate.aggregate(Aggregation.newAggregation(Aggregation.group(categoryFields.stream().toArray(String[]::new))),"recipe",Category.class );

Distinct:

 categoryFields.stream().forEach(cat -> 
 categories.put(cat, mongoTemplate.findDistinct(query, "categories." + cat, "recipe", Recipe.class, Category.class));
 );

Aggregation taking 11sec and Distinct taking 3 secs both slow on performance side .

java spring-boot spring-data-jpa mongodb-query spring-data-mongodb

share|improve this question

edited Mar 26 at 11:50

sankar

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

add a comment | 

1

[
 
 "categories":
 "category":[
 "sub1",
 "sub2",
 "sub3"
 ],
 "category2":[
 "sub1",
 "sub2"
 ]
 
 ,
 
 "categories":
 "category":[
 "sub1",
 "sub4"
 ],
 "category2":[
 "sub5",
 "sub4"
 ]
 
 
]

want to get the distinct category and category2 using Spring data. I have tried both Aggregation and Distinct both slow on performance i hope i am missing something

Aggregation:

AggregationResults<Category> results = mongoTemplate.aggregate(Aggregation.newAggregation(Aggregation.group(categoryFields.stream().toArray(String[]::new))),"recipe",Category.class );

Distinct:

 categoryFields.stream().forEach(cat -> 
 categories.put(cat, mongoTemplate.findDistinct(query, "categories." + cat, "recipe", Recipe.class, Category.class));
 );

Aggregation taking 11sec and Distinct taking 3 secs both slow on performance side .

java spring-boot spring-data-jpa mongodb-query spring-data-mongodb

share|improve this question

edited Mar 26 at 11:50

sankar

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

add a comment | 

[
 
 "categories":
 "category":[
 "sub1",
 "sub2",
 "sub3"
 ],
 "category2":[
 "sub1",
 "sub2"
 ]
 
 ,
 
 "categories":
 "category":[
 "sub1",
 "sub4"
 ],
 "category2":[
 "sub5",
 "sub4"
 ]
 
 
]

want to get the distinct category and category2 using Spring data. I have tried both Aggregation and Distinct both slow on performance i hope i am missing something

Aggregation:

AggregationResults<Category> results = mongoTemplate.aggregate(Aggregation.newAggregation(Aggregation.group(categoryFields.stream().toArray(String[]::new))),"recipe",Category.class );

Distinct:

 categoryFields.stream().forEach(cat -> 
 categories.put(cat, mongoTemplate.findDistinct(query, "categories." + cat, "recipe", Recipe.class, Category.class));
 );

Aggregation taking 11sec and Distinct taking 3 secs both slow on performance side .

java spring-boot spring-data-jpa mongodb-query spring-data-mongodb

share|improve this question

edited Mar 26 at 11:50

sankar

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

[
 
 "categories":
 "category":[
 "sub1",
 "sub2",
 "sub3"
 ],
 "category2":[
 "sub1",
 "sub2"
 ]
 
 ,
 
 "categories":
 "category":[
 "sub1",
 "sub4"
 ],
 "category2":[
 "sub5",
 "sub4"
 ]
 
 
]

AggregationResults<Category> results = mongoTemplate.aggregate(Aggregation.newAggregation(Aggregation.group(categoryFields.stream().toArray(String[]::new))),"recipe",Category.class );

 categoryFields.stream().forEach(cat -> 
 categories.put(cat, mongoTemplate.findDistinct(query, "categories." + cat, "recipe", Recipe.class, Category.class));
 );

share|improve this question

edited Mar 26 at 11:50

sankar

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

share|improve this question

edited Mar 26 at 11:50

sankar

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges

asked Mar 25 at 21:27

sankarsankar

1891010 bronze badges