A little update on the CMS system. I've decided to go for a full on JSON powered site, run it all via javascript....this does mean that the i'll have to create a fall back system for the indexing.

The main page will use flush to pop out the javascript. Get the paged loaded, and the then content will be rendered from JSON. This is rather simple in drupal. the really nice thing is i can use Views 2 to both the fall back system and to access the database without too much custom MySQL. Hand coded SQL is never that fast, and views can cache it all. This should decrease loading times.

Also use Boost to create static pages of everything. that way, CPU load decrease and content should load quicker again.

Roadmap to follow.