I noticed that the newest Lyceum draws 109 queries and Lyceum 0.32 only 19 ( in both cases no blogs created )
Having a shared web hosting there are more chances to receive something like "notification that your shared hosting account is about to be suspended due to excessive usage of the mysql service".
Is any way to reduce that load by, let's say, disabling something?
I'd try to use caching, let's say memcached (make a query hash as a key, and the result as value). Also, you can get rid of temporary table creation in portal.php, modify the 'latest posts' query, etc.