• Subject: Re: Quick field scan
  • From: "Dennis Lovelady" <dennis@xxxxxxxxxxxx>
  • Date: Mon, 19 Jul 1999 20:02:05 -0400

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
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].