× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I am using my first UDF on a single field and the results are good.

But, the performance seems to be poor. The process is a little complex due
to the file structure. I have a file for the current 3 months of orders.
There is another file containing the current years records after being
transferred from the current file and finally another file with the
previous years data.

There are a total of approximate 400k records in all the files.

I have UNIONed the files.

The question on performance is:

- Does the system apply the UDF values at program initiation time, like
*INZSR or simply at the time the record is read?

TIA

Darryl Freinkel

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.