Not signed in (Sign In)

Vanilla 1.1.2 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthormikhail
    • CommentTimeNov 11th 2007
     permalink
    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?
    • CommentAuthorpari
    • CommentTimeDec 20th 2007
     permalink
    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.
    • CommentAuthorjohn
    • CommentTimeApr 5th 2008
     permalink
    Yeah the sql in portal.php is pretty sloppy at this point. Be sure to remove anything there that you don't need.