Besides that obvious bug, one should remember that CB can quickly load a cpu of a dedicated host.
Don't forget we are working with a CMS system that uses PHP files, not simple static pages.
When you are enthousiasticaly programming nifty stuff and publishing it on the site, like i did, you will soon get that email from your hosting provider that they want to ditch you because of excessive server load.
Thats how i got myself a dedicated server.
This dedicated server however is a 2.4ghz with 1gig memory
My database is 65 megs.
My load average is around 3.00 ! I want it below 1.00
This is how a request looks:
18654 mysql 16 0 124M 32M 15736 R 6.5 3.2 0:02 0 mysqld
18789 apache 15 0 14440 11M 3928 R 3.5 1.1 0:00 0 httpd
As you can see, myself is using 124 meg, and that is with connection path off. If i'd turn that resource heavy feature on it will cost me 30% more load.
When you install and use plugins or features, be smart and think about what you are asking the machine to do, some features might not be worth it, others might not be such a big load.
Right now my site has hit the limit for the past 3 months, my server cannot server more than the current number of requests. I'm at 5500 unique visits per day and then pages will be served slow so some users quit trying.
My datacenter tells me I cannot spend enough money to make this problem go away. So tripple dual core xeons won't do much good -for long-.. as i will soon hit that roof too..
PHP is just CPU extensive, and Joomla and CB and their components and plugins can do powerful (read, cpu heavy) things.
This post is for more for the ppl that are new in mambo/joomlaland that like the idea of 'making a website' that wanna install and tryout everything they see. Don't do it blindly but think a little.., or you get that mail from your host
Iow, be wise
~T.