[Paul M]

Hmm, looking at this on my homepage, mysql is not using the index for some reason, even though it exists. By forcing it the query is quicker.

Change the SQL call (in Plugin 3) to this and let me know what happens ;

PHP Code:

    $todaysguests = $vbulletin->db->query_read_slave("
        SELECT * FROM ".TABLE_PREFIX."guest FORCE INDEX (lastactive) WHERE lastactive > $cutoff
    ");