Re: Database I/O throughput speeds

[Alan Campin <alan0307d@xxxxxxxxx>]

Can you use SQL and arrays? You will see a tremendous performance increase
reading in many records at a time.

There are so many variables I doubt you could make any estimate of what
difference it would make.

On Tue, Jan 18, 2011 at 3:56 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

> Unless you designed your batch job to run multiple parallel threads, then
> it
> will probably just use 1 of the CPUs, even on a 16 CPU server. It's known a
> CPU
> affinity. So your question probably comes down to how much faster the new
> CPUs
> are.
>
> -Nathan.
>
> ----- Original Message ----
> From: Vinay Gavankar <vinaygav@xxxxxxxxx>
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Sent: Tue, January 18, 2011 2:34:48 PM
> Subject: Database I/O throughput speeds
>
> Hi,
>
> Can any one give me some ball-park figures for number of I/O operations
> (chain, update, write, delete) that can be achieved (per second or per
> minute) in an RPG program running in batch mode (priority 50) on a high end
> newer model? I am not sure what model my company is going for, but it is
> supposed to have 16 CPUs (if I heard it right). I realize that the
> throughput may vary based on the other usage of the system, but I would
> have
> something to go by.
>
> I am trying to gauge the impact of adding a few I/O operations to every
> transaction when processing a batch of 1-2 million transactions. Our
> development machine has nowhere near that power, so running a sample
> program
> on it would not tell me much.
>
> Thanks
> Vinay
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.