RE: Accessing files In QTEMP

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Try to clear a member on a triggered file.

Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000

-----Original Message-----
From: Richard Jackson [mailto:richardjackson@richardjackson.net]
Sent: Thursday, October 19, 2000 2:48 PM
To: RPG400-L@midrange.com
Subject: RE: Accessing files In QTEMP


It depends :)  If the SQL delete is phrased "delete from file" (no where
clause) it goes pretty fast - unless the file is journaled.  The clear will
probably be faster unless you need to keep the 500,001-th record and you
have to recover it from backup or some such silliness.  When a clear is
used, the journal records a message "file cleared" and separate journal
entries are not written for each database record.

I believe that the physical space allocation is truncated if you do a clear
and that would exercise the storage management code a little bit but nothing
like the exercise that the database code would get if you deleted 500,000
records one at a time

Richard Jackson
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325
+---
| 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
+---