simplifying index to improve performance
performance enhancements
improving model, updating view for new model, performacne enhancements to views
revising database settings