I've been looking into trying to minimize b2evo's use of system resources. I have had all kinds of problems with my server and the company (of course) blames the software, saying it's inefficient.
I am going to change companies soon, but this got me thinking about making 'static elements' instead of static pages.
For example, If my sidebar never changes (except for the calendar), I could conceivably just put all of the other parts (description, links, categories, etc...) directly into the main body php file.
I could also do this with the title, meta tags, etc.
Then, the only thing the database would be accessed for are the stories and comments.
How does this sound? Other than not being able to make easy changes, what other problems do you forsee?
I did this and my memory usage went down from 95% to about 80%. My swap file size went down 75%.
I'll have to see if I get the "Too many connections" error again.