Skip to Content (Press Enter)
2021-03-20 23-21-57
Bryce Lynch
137Views
2Comments
Solved
What is the fastest way to retrieve a record by Id?
Question
Aggregate
Database

I am curious about what the most performant method to fetch a specific record from a database given the record id is.
The only methods I'm familiar with would be:
1) Use the 'Get' action created with the DB entity
2) Use an aggregate, set the source to the desired DB entity, and filter by id.

Which would be faster, and why?
Or is there anther method that would be faster than either of those two?
Thank you!

0
0
30 Nov 2021
Copy Link
2021-11-08 12-36-10
Pedro Canário
Solution

Hi,

See this article that has a detailed explanation of the differences between the two cases, it's a good article.


Best regards,

Pedro C.


1
0
30 Nov 2021
Copy Link
2021-03-20 23-21-57
Bryce Lynch

Thanks for pointing me to that article Pedro!
That's really in depth, I appreciate your help.

1
0
30 Nov 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.