Re: Quick field scan

["Dennis Lovelady" <dennis@xxxxxxxxxxxx>]

Hi, Folks:

From: Greg Behymer <greg.behymer@cm-inc.com>
Sent: July 19, 1999 7:01 PM


> Is your file a physical or logical file?  A logical would take a longer
> to retrieve than a physical.  I assume a spool file is like a physical
> (no key).

Actually, a spool file is more like a *USRSPC object in that it is a space
object.  It does not have records, fields, or the like - it is an
unstructured stream.  The machine interface instruction SCAN, working on
an object of that nature, is extremely fast.  When physical or local
datafile reads are involved, the process naturally slows down.  User code
on top of that, slows it down even more.  Calls to external programs (some
people use QCLSCAN, for example) increases the overhead, and the
performance of scanning a single object cannot be competed with under
those circumstances.

HTH
--
Dennis Lovelady                    Fayetteville, GA
mail: dennis@lovelady.com          dennis.e.lovelady@ac.com
URL:  http://www.lovelady.com  **NEW**
ICQ:  5734860
--
"Insanity is hereditary; you can get it from your children."
        - Sam Levenson


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