Hi

Much quieter site. Size of the database 12 MB; this year (average daily use):
211 unique visitors, 15 simultaneous connections, 761 visits, 1,090 pages, 2,815 hits, bandwidth 6.28 MB.

For comparison: size of the database is 156 MB, 219,675 unique visitors, 881,148 visits, and 730 pages.

Yep, but we have to compare your daily use: ~1,500 unique visitors, ~2,500 visits, ~16,000 pages. So that’s one order of magnitude larger than mine. As I have seen the last two days you serve about 2–5 times more connect’s. So I posit the bottleneck is the database indeed. Due to performance issues (slow rendering by GeSHi) Alex opted in mlf for two tables: One keeping the original entry with BBCodes, and a cache-table – containing already rendered HTML. Instead of calling GeSHi all the time, the code looks up whether there is already an entry in the cache-table. If yes, GeSHi is bypassed. Quick question: What are the sizes of both tables in your installation?