openlearningtools / opencompetencies

A tool for organizing educational competencies.
MIT License
16 stars 3 forks source link

Optimize view queries #26

Open ehmatthes opened 11 years ago

ehmatthes commented 11 years ago

I have not optimized queries at all at this point, so some views, such as entire_system, have many db calls. This is not affecting performance noticeably with so few users, but I can't imagine the site would do well with any decent pr exposure.

The first round of optimization should involve some simple profiling, and some simple use of fetch_related and prefetch_related as appropriate.