Re: front page takes 50 mysql queries
OMG. This is insane.
Go edit your front-page.php, forum.php and view.php templates.
Change
topic_last_poster();
to
echo $topic->topic_last_poster_name;
Cuts mysql queries in half. I went from 50 to under 20.
The data is already in the retrieved topics in memory, there’s no need to reload all the userdata.