• Requirement
  • Get the list with days_to_refresh, for making that we need to merge the features_options between job, team, and parent_team. With this query, we can order by days_to_refresh, filter by this field.
  • Query for get the list (take ~1 sec)

Problem

• Currently: Django uses the join query to fill all information, like count of the result and make the pagination, filters information. Then the page takes > 10 seconds.
  • Counts
    • Query Parser → take ~ 4.5 sec (We need to check all rows and the query inherited the group by and order)
    • Show Full Result Count
  • Filter by:
    • Published → 0.8 sec
    • Category → 0.8 sec
    • Days to refresh → 4 sec
      • Query

Review app link

Solution

The response time was reduce ~30% the original time.

• Fix Counts with the custom Class for pagination.

• Set show_full_result_count = False

• Create filter for category.

• Use a raw query for get the Days to Refresh, because the SQL query is hard to translate to Django ORM.