On Sat, 31 May 2008 21:03:21 -0700 "Emmett Shear" <[EMAIL PROTECTED]> wrote:
> - Observe that updates and inserts in the database (postgres) are becoming > slow. And by slow, I mean 30-40 seconds for a simple insert or update where > it previously took less than 0.1 seconds. Load on DB server itself remains > nominal; less than 2 on an 8 core box. No error messages of importance that > I can see. Inserts and updates from other sources (script/console, psql) are > fast. Well, it sounds like your site already has some traffic. Without getting into a remote debugging session, have you checked your indexes to make sure you're adding the right ones to the right columns? If you were say entering a ton of strings into a DB and then querying for them with insane LIKE clauses, you'd see this kind of behavior. As you added more rows your app would get slower and slower. -- Zed A. Shaw - Hate: http://savingtheinternetwithhate.com/ - Good: http://www.zedshaw.com/ - Evil: http://yearofevil.com/ _______________________________________________ Mongrel-users mailing list Mongrel-users@rubyforge.org http://rubyforge.org/mailman/listinfo/mongrel-users
