[voter]

Originally Posted by 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
    "); 


This query takes sometime 25 seconds in my forum? Any idea what it could be or better how I can solve the problem?