As my friend Otto42 suggested, I am posting a new thread here to see if anyone has comments regarding how to resolve CPU overloads.
I am currently running WP 2.3 using i3Theme v1.5 on th HostICan Tera plan (shared).
2007 saw zero CPU overloads. 2008 already seen quite a bit of overloads. And the strangest part was nothing was changed so I reinstalled WP and cleaned the database up and started deducting possible issues.
These are the possible issues I have started working on and noticed a significant improvement to the process.
Deleted images in the Upload folder that were no longer there because of reinstallation. This resulted in a huge difference. As a result, I am now working on new images with file sizes of 50k or less.
I also have disabled stats plugins including Tan Tan WordPress reports and Semiologic Google Adsense and this also resulted in a noticable difference. All I had to do was just insert the Google Anaylsis code into the footer and disable the plugin, removed from the plugin folder, cleaned up the mySQL database.
I am using a number of plugins all except for 2 of them which are 4KB,
Two possible issues I am exploring right now is the index files including trackbacks and spiders bots (cron jobs).
I am considering removing the popularity plugin as well as the live preview since the commenters can edit their own comments after publishing using the ajax edit comment plugin.
Any suggestions to further optimization of my wordpress structure will be appreciated.