Something is killing my server

[Morgalis]

My site just got a lot busier, and it's killing my site!

I have quite a few hacks in, nothing truly extravagant though such as karma, rpg, store et al

i have turned on debug mode and for index.php i got

Page generated in 49.8040850163 seconds with 28 queries,
spending 45.3688160181 doing MySQL queries and 4.43526899815 doing PHP things.

so i used Xenon's optimizing and got down to

Page generated in 11.122871995 seconds with 23 queries,
spending 10.1487640142 doing MySQL queries and 0.974107980728 doing PHP things.

i'm attaching the printout of the optimized debug output

i need some fast advice =/

[MUG]

The hack that shows the number of posts & threads since your last visit is causing problems.

--------------------------------------------------------------------------------

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1057397209'
Time before: 0.556862950325
Time after: 7.43775296211

That query took 7 seconds...

[Morgalis]

actually i removed that as i saw it [not sure why it all of a sudden is causing problems] and i'm down to

Page generated in 4.09157001972 seconds with 21 queries,
spending 2.20456910133 doing MySQL queries and 1.88700091839 doing PHP things.

[Erwin]

4 seconds is still a bit slowish. Are you on a shared or dedicated server?