Improve server performance, specifically API requests

Question

Improve server performance, specifically API requests

Opened this issue 7 years ago · 11 comments

some requests take 12s

2017-08-16T04:53:47.239591+00:00 heroku[router]: at=info method=GET path="/measures" host=undp-sadata-staging.herokuapp.com request_id=8b30a393-77b4-4f79-b16f-5d1a62e01b68 fwd="210.246.55.14" dyno=web.1 connect=0ms service=12698ms status=200 bytes=369010 protocol=https

Answer 1 · 2017-08-16T05:08:46.000Z

May also be related to #264?

Answer 2 · 2017-08-16T05:22:20.000Z

tmfrnz commented 7 years ago

Answer 3 · 2017-08-16T05:25:17.000Z

While individual requests for our "larger" tables (eg measures, 250 rows) take "only" ~2.5s, when requesting multiple tables concurrently the same table may take ~12s

Answer 4 · 2017-08-20T22:45:36.000Z

Production site with "Standard 0" DB plan

Staging site with "Hobby Dev" DB plan

Answer 5 · 2017-08-20T23:03:14.000Z

While the download time appears reasonable , I wonder @barancw if and how we can reduce the waiting time?

Answer 6 · 2017-08-22T05:16:08.000Z

improve waiting times on production

Answer 7 · 2017-08-22T05:16:37.000Z

@barancw should we merge yesterday's updates into master?

Answer 8 · 2017-08-31T13:44:01.000Z

@barancw have merged recent changes from production into master. While there appears to be some performance gain (requests no longer exceed 30s when they time out), still measures table takes 20s to load

Answer 9 · 2017-08-31T13:45:02.000Z

@barancw should default_scope { includes(:versions) } be also added to other models (currently added for recommendations and categories only)?

Answer 10 · 2017-10-26T16:30:02.000Z

@barancw have added default_scope { includes(:versions) } to other models 316a4a4

Answer 11 · 2017-10-26T16:31:53.000Z

This gives significant performance gain (~half). Still API request times are not acceptable so we will need to investigate