Just a quick note to let you know that there is a new script located at 'bin/kontroll-query_cache_preload.pl'. You can check out the souce code here if interested.

Basically what it does is run every X number of minutes if you put it in crontab and it executes the queries that are used to generate the various page data and views during the login process. It does this so that the query cache stays populated with the login data so that when you login it reads the data from the cache instead of running it all over again from disk – the results end up being anywhere from 25-50% faster logins depending on you query cache settings and the interval that you have the script running. Here is my crontab entry for the script.

This script was added in revision 202 and finished in revision 204.