oh... on MySQL
"Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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