Best way to count the number of rows

[eluser]Cro_Crx[/eluser]
Hey Mike

Thanks for the response. Yeah I could use triggers, it's not a bad idea, i'm just wondering if there would be much benefits as I hear MyISAM can do count(*) quite quickly.

Yeah I was reading that Oracle bought out Sun Microsystem, I didn't realise that MySQL was a part of sun. Anyways, i run my own server so I could install Oracle if need be, although i'm much more familiar with MySQL installs.

I tried to search but couldn't find any more info, i wonder if anyone knows if count(*) is quicker or quick enough rather than using denormalization