Mutiple SQL count() from several tables

[eluser]tonanbarbarian[/eluser]
you need indexes not just primary keys
indexes help to lookup the data quickly
for example when you are joining users to pm
you users table has the primary key which is good
but if the pm table does not have an index (or key) on the user field then it will slow down the join between user and pm