Details
-
Bug
-
Resolution: Done
-
Major
-
2.7 ER1
-
13
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
Not Started
-
3scale 2019-09-30, 3scale 2019-10-28, 3scale 2019-11-11, 3scale 2019-11-25, 3scale 2019-12-09, 3scale 2020-03-09, 3scale 2020-03-23, Invalid Sprint
Description
Affected version [NIGHTLY-415]
With many products/backends system rapidly slow down. Tested on 1k+ backends and 400+ products.
Also tables with products and backends are very big. There may be used pagination.
Dev Notes
investigate:
- possible missing indexes
- delete warning lists all products/backends
- dashboard pagination
"small quick things" commented in slack:
- fetch the attributes u need only and not the whole objects with all its data even if u r not going to use it.
.select(...)??
- looking for db indexes that might be added to speed things up
- careful also with N+1 queries