[trackpads]

Originally Posted by trackpads

Ok, I had deleted the award not set to Zero so I re imported the default awards and set to zero. However, now instead of scanning a bazillion rows it only scans 5-6 but still takes for ever.

Can I just remove this from the code so it doesnt do anything at all?

# Time: 121110 15:52:28
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.705497  Lock_time: 0.000074 Rows_sent: 1  Rows_examined: 1
SET timestamp=1352580748;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32317
                        AND T.dateline > 315532800 AND T.dateline < 1352580745
                        AND P.dateline > 315532800 AND P.dateline < 1352580745
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;
# Time: 121110 15:52:37
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 1.297763  Lock_time: 0.000075 Rows_sent: 1  Rows_examined: 5
SET timestamp=1352580757;
SELECT
                        P.userid, COUNT(userid) AS times
                        FROM vb_thread AS T
                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid
                        WHERE P.userid=32320
                        AND T.dateline > 315532800 AND T.dateline < 1352580755
                        AND P.dateline > 315532800 AND P.dateline < 1352580755
                        GROUP BY P.userid
                        ORDER BY P.dateline DESC, P.userid;

Anyone?