I am looking at creating a 30K hit a day web pages that is intensely database driven. I have looked into MySQL clusters, and was wondering if anyone here had any resources and/or experence based advice on working with these technologies.

I am also wondering if pulling a large amount of data from one tables vs many tables matters for speed. Normally, DB wise, I am a table whore as I am a strict OOP minded fellow. Does MySQL handle this approach just as fast, or should I tweak down the number of tables I make? Any other speed affiliated tips?

I think that is all for now I have been whoring up the MySQL page for about a long while, and have yet to see a decent responce to the above questions.


your friendly neighborhood GOE.