wiki:MahitiImprovement

Frontend Optimisations

  • Combine JS
  • Combine CSS and maintain order
  • Set cache-control headers to enable browser caching for images / JS / CSS - Done[mahiti]
  • Enable gzip compression - Done[mahiti]
  • Change in focus and loading the form when editing students
  • Thickbox called 30 times for 30 students

Database Optimisations

  • Fullhistory_fullhistory - reports are slower - Not required as data is already partitioned[mahiti]
    • Inserts are slower
    • Archive till 3 months
  • Archive these tables wherever possible as these are hit the most
    • school_relations
    • schools_answer
    • schools_child
    • schools_student
    • schools_moi_type
  • Optimise these auth_* tables
    • auth_user
    • auth_permissions
    • auth_groups
  • Watch the Dashboard with heavy Transactions in New Relic

Server Optimisations

  • Provison additional CPU/ memory - done [Gautam]
  • Increase number of connections and threads per connection in apache wsgi config - Done[mahiti]
Last modified 4 years ago Last modified on 03/10/14 18:47:36