Oh good lord... I thought my Drupal sites were fine until for one of them it required a small amount of logged-in users. Performance was terrible so I enabled some dev module to see what was going on. I was faced with a ridiculous amount of queries, each of full of joins.
I now don't use Drupal anymore, although I might occasionally whip it out for a site that only requires a few admins to log in...