Where are all the other details that are mandatory when performing a "performance" test?
Number of disk drives? Speed of disk drives? What RAID configuration are the disk drives in? Is the system running anything else? Is only a fraction of the processor allocated to this LPAR? Are there other LPARS running on the machine? How many other interactive users are currently on the system? Etc, etc, etc
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Wednesday, September 04, 2013 11:32 PM
To: midrange list
Subject: How to handle Big Data under IBM i?
Let me admit up front that this message is something of a teaser.
While experimenting to better understand how IBM i might handle "big data", I inserted 130,000,000 rows into a table, using an RPG program that required 260 seconds of elapsed time to complete on a 2-core model 720 - P05 Group.
When I shared the results in a Linkedin discussion, a couple antagonists expressed doubt in my numbers. They didn't believe one could insert 500,000 rows per second, even using a model 795, and they didn't view IBM i on Power as a viable platform for hosting and handling "big data".
Say you have a need to record millions or billions of records quickly and read them quickly. How would you do it?
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l