Ah I am still in conception at the moment. Moving on from design. I have chosen a massively multi table approach. For instance, page color and themeing is all take from the page database, while other tables will hold the cms content, aother for personalised content, another for user information etc. There are 14 tables in all thus far - 5 which are regularly queried and linked in groups of 2 - 3. Fairly straight forward. I have to admit, I have never used the EXPLAIN function, though I am very compitant in DB design (I think). Now to check my previous tables with this newfound tool!

My biggest challenge, I think, is going to be the cluster. *gets pumped*