Slow loading

[bartmoss]

MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)

[Robbie]

MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)

From what I'm reading, yes it is...I need to make sure I can install it on our server. I think we can install whatever we want. How are the load times for you right now?