Re: Accessing Database vs Dataarea [PRIVATE REPLY]

Hi, Vinay:
* >>>---> private reply off-list <---<<<*

I would like to see the source code for your little "benchmark" tests of accessing a data area vs. a record in a file, so that I can run it on several different models of iSeries systems, and to see what results I obtain.

If you can, just download the source to a PC as text files, zip them and attach that to your reply, or even just attach the text files directly.

Thanks in advance.

All the best,

Mark S. Waterbury

> On 4/21/2017 5:42 PM, Vinay Gavankar wrote:

Hi,

We have a program where same record of a 'control' file (input mode) is
being read for every iteration, and I thought that replacing the 'Chain'
with reading a dataarea.

So I ran a simple test to compare the time taken to read one record in file
100,000 times and reading a data area 100,000 times with 'IN' statement.

I was surprised that the file was read under 1 sec, whereas dataarea took
around 4-5 seconds.

Just to make sure, I looped for a million times. The file came in at 4
seconds and dataarea at 47 seconds.

I was wondering whether I am missing something or accessing a dataarea with
an 'IN' statement takes that long compared to file read.