Almost 90% of the queries are in DAL and not native SQL. Nothing too elaborate but there are a number of queries with joins - nothing elaborate and simple where clauses. I know the model is not the primary bottleneck as I've got thick controllers that definitely need to be thinned out and re-organized. I'm also moving stuff off into modules - I didn't install from source so I'm going to do that next.
The reason I'm focusing on the model file is my homepage is static and loads from a pretty thin controller and it loads very slowly. So I assuming it's something I neglected to do. I definitely check into Massimo's comments about conditional models. I'm confident that whatever is the problem it is of my own making. --
