Re: High Volume Inserts

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 04 Oct 2005 11:21:42 -0700
Message-ID: <1128450095.961518@yasure>

srinivas.somayajula_at_gmail.com wrote:
> All,
>
> We are building an application using Websphere MQ coupled with
> Websphere Application Server on 2 solaris 5.9 servers (Sunfire 6800 &
> 4500)
>
> The intent of the application is to pull messages from the queue,
> perform some validation, and insert to the database. During our
> performance testing this is what I encountered:

Follow Jim Kennedy's advice.

On my single CPU notebook with a single slow hard disk I have no problem using the array interfact to insert 28,700 records per second.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Oct 04 2005 - 13:21:42 CDT