PHPEverywhere has a link this morning to an article that talks about setting up some temporary tables to help with some of the more advanced querys.Temporary tables are per connection so heavy loaded sites will not have a problem with using the same table name since it's unique per connection. Some fun stuff here, worth checking out.
Also, I'm still working on the new backend for the site, so don't think I've just abandoned it. I'm rewriting a lot of the code (most of it because I was so new to PHP the first time around) and I'm working new images and other things into the new layout. For those that haven't seen it yet, visit this link to see what you think and voice it over in the forums.