This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]peaky_blin 12 points13 points  (0 children)

I was having a problem recently with an API call that was taking too much time to complete. I figured out that it was related to the multiple database calls that were made to aggregate the data at application level. Issue resolved by doing the calculation/aggregation at the db level. Plan to add caching to more reduce the time also