Hi,
Put indexes on 'valid' and 'sessiontype' and all will be good.
Cheers,
Andrew
On 15/7/05 18:26, "Kishore Jalleda" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have a mysql query which takes 8 seconds to run ona dual
> xeon 2.4, 3Gig ram box,
> SELECT gamename, MAX(score) AS score, C
Hi All,
I have a mysql query which takes 8 seconds to run ona dual
xeon 2.4, 3Gig ram box,
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN (1,2)
GROUP BY gamename;
Explain sel
