Thanks for the comments guys….I just wanted to know if I was going to have any problems as the network grew. I am currently on a VPS with I think 1280 MB RAM. My install of buddypress never takes more than a half a second to run the queries so it sounds like I’m getting good times…though I just have a handful of beta testers right now.
I may try the multi-db plugin, but it seems that the problems that I’ve been having over the last couple of days are due to my host and not my buddypress install…my sites have all been down for the last 4 hours.
One last question for jedbarish or anyone else who wants to contribute…can you explain why it is best to run MySQL from a different server than the WPMU install?