> 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
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',
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