Hi there, I have a user table, containing a column on gender. Type is tinyint(1) and 1 is male 2 is female. No index. 50000 entries
This statement: SELECT sex, count(*) AS c FROM user GROUP BY sex takes 1.5 s to execute I am wondering if ti wuold be possible to find this out any faster ? SELECT count(*) AS c FROM .user where sex = 1 takes about half the time :-) So maybe some of you guys do have some experiance on that. This is just way to long. I appreciate every help on that, Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php