RE: Reading files with MI (speed)

[Leif Svalgaard <l.svalgaard@xxxxxxxxxxxxx>]

I guess these times are for Reading, what was the time
for writing?
The conclusion seems to be that although there is a
difference (MI being about 20% faster) it is not a LARGE
difference.

> -----Original Message-----
> From: Francesco Scafi [SMTP:fscafi@tin.it]
> Sent: Tuesday, November 23, 1999 5:25 PM
> To:   MI400@midrange.com
> Subject:      Re: Reading files with MI (speed)
> 
> Hi Leif,
> the table time without ovr is:
> 
> Records       MI              RPG
> ---------     ------  ---
>   100.000     31"             37"
>   500.000     2':31"  3':14"
> 1.000.000     5':5"           6':15"
> 
> hi all,
> Francesco
> 
> At 14.28 22/11/99 -0600, you wrote:
> >Here is a simple program that opens a file TESTFILE created
> >with CRTPF FILE(TESTFILE) RCDLEN(132) SIZE(*NOMAX) LVLCHK(*NO)
> >and writes 100,000 records, then closes the file and opens it again
> >and reads the 100,000 records back. A message is sent to your
> >message queue after writing and after reading telling you how many
> >seconds it took. On my little 150 box the timings were as follows
> >Write 100,000   72 secs
> >Read 100,000   55 secs 
> >you can decrease the reading time by override of the number
> >of records to read at a time:
> >OVRDBF FILE(TESTFILE) NBRRCDS(10000)
> >It doesn't make much difference (2 seconds).
> >
> >You can try to do the same in RPG and/or C so we can
> >compare timings.
> >...
> 
> +---
> | This is the MI Programmers Mailing List!
> | To submit a new message, send your mail to MI400@midrange.com.
> | To subscribe to this list send email to MI400-SUB@midrange.com.
> | To unsubscribe from this list send email to MI400-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> dr2@cssas400.com
> +---
+---
| This is the MI Programmers Mailing List!
| To submit a new message, send your mail to MI400@midrange.com.
| To subscribe to this list send email to MI400-SUB@midrange.com.
| To unsubscribe from this list send email to MI400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dr2@cssas400.com
+---