RE: Fastest way to delete records.

Gee - sorry i offered an opinion.  Thanks for the attack.

btw,  it was not a statement at a seminar,
but a fairly long discussion with the lads in Rochester.

if you read  my original posting in full, you would see i made mention of a 
minor point
about the file being volitile.  that would translate to a situation like:-
If it is a high volume transaction file being accessed by numerous programs 
in update/add/delete mode
the whole time,  then, no i would not recommend using a 'Reuse Delete" file 
as acceptable.
If it were a fairly low volume transaction rate file, then yes - I would 
think it acceptable.
There are also some other situations that might make it acceptable - but, 
you obviously know that sir.

I also made a point of saying that I had not followed the thread of the 
emails discussing this situation,
so - if it is a situation that would make it acceptable to use "Reuse 
Deleted records" -
i thought i had excused myself by that disclaimer.

but. i obviously bow to the superior knowledge previously expressed in the 
response to my posting,
and will think twice before offering an opinion.


btw.  I would hope you spend more time fact gathering than making 
assumptions when developing applications.
like:-
      If I had a 100 million record file,  I would consider the 
impact.  Just as
      Mr. Turner(who I know and respect) should consider the impact of
      generalized  statements at seminars to people who think it applies
       "Everywhere, everytime situations"

I do not think it was necessary to put down a specialist like Rick during 
your *rants*
i must thank you for stopping short of actually calling me an idiot,
although the insinuation is there.

just my humble opinion.



  At 07:38 AM 02/09/2001, you wrote:

> >Dunno if much has changed with 4.5,
> >but last I spake with Rick Turner and the performance lads in Rochester ,
> >they did not promote 'Reuse Deleted Records' attribute on files.
>
>Thats what I love about performance seminars,  They say those things and
>people believe them.   I remember programmers arguing against having
>functional subroutines because they went to a John Sears session and John
>said that "For Performance straight top down programming is faster"
>
>I went to an audio store one time and the sales man told me about a tape
>drive that had .00000001 wow and flutter,  I asked "What can a human
>physically hear?"  Well only about .01 .
>
>Sorry for the rant.  But its like saying that 30 seconds off a 10 minute
>runtime is cause for a change of programming techniques.
>
>We use "Reuse Deleted"  on all our files and never have to worry about
>them. And no noticeable performance impact.   Do we have huge files?  No,
>Should we worry about IBM not "Promoting" reuse delete in our shop ?  No.
>
>If I had a 100 million record file,  I would consider the impact.  Just as
>Mr. Turner(who I know and respect) should consider the impact of
>generalized  statements at seminars to people who think it applies
>"Everywhere, everytime situations"
>
>rant *off
>
>John
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---