Re: [PERFORM] Terrible Write Performance of a Stored Procedure

2009-06-26 Thread Brian Troutwine
> Turn commit delay and commit siblings off. Why? Brian On Fri, Jun 26, 2009 at 1:06 PM, Scott Mead wrote: > -- sorry for the top-post and short response. > > Turn commit delay and commit siblings off. > > --Scott > > On 6/26/09, Brian Troutwine wrote: >> Hell

Re: [PERFORM] Terrible Write Performance of a Stored Procedure

2009-06-26 Thread Brian Troutwine
Hodgson wrote: > On Friday 26 June 2009, Brian Troutwine wrote: >>  CREATE TABLE amazon_items ( >>         asin         char(10) PRIMARY KEY, >>         locale       varchar(10) NOT NULL DEFAULT 'US', >>         currency_code char(3) DEFAULT 'USD',

[PERFORM] Terrible Write Performance of a Stored Procedure

2009-06-26 Thread Brian Troutwine
Hello, all. I'm finding that write performance of a certain stored procedure is abysmal. I need to be able to sustain approximately 20 calls to this procedure per second, but am finding that, on the average, each call takes 2 seconds in itself, in addition to pegging a single processor at 100% for