Pete, Quoting Pete DeLaurentis <[EMAIL PROTECTED]>: > Yeah, all the foreign keys are indexed. I'm also caching what I can > in our ruby app's memory. > > It seems to be the database writes that are taking up a lot of the > time. The other offender are some multiple JOINs we're doing. > > I've ordered more processors for the database server, and am clearing > off a second machine so I can get a little MySQL cluster going. Any > advice on this is welcome since I've never scaled a database server > before.
I've never done that either...what about memcached....or that's already similar to what you are doing in memory? We use it on one of our non-rails apps and it seems to do a good job of improving performance...I don't know or understand a huge amount about it, but thought I would bring it up. Maybe one of the "Smarter Folks" would be able to help out with that. Mike B. <snip previous conversation> ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. _______________________________________________ Mongrel-users mailing list [email protected] http://rubyforge.org/mailman/listinfo/mongrel-users
