Graham_Aberdein1
Active Member
Hi there,
We are experiencing some fairly lengthy run times (sometimes in excess of
2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
has close to 60 million records). In looking at the joblogs, it appears
that where we have joined the F0911 to another file (e.g. the F0006 to get
BU category code information or BU description, or the F0010 to get current
reporting date and fiscal year), the program zeroes in on the joined fields
as the "keys" for indexing. It also appears that in some cases it cannot
use an existing logical file and creates one (I may be wrong on this
assumption).
The question is, can you define a specific logical file within the
Worldwriter screens? It appears to us that the optimizer scans the logical
files for the "best fit" based on the extraction criteria including joins
within the Worldwriter (again, I may be wrong on this). If so, can we
create our own logical file(s) and specify the appropriate one to be used
with each Worldwriter?
Another related question is, has anyone created "partitions" of their F0911
(e.g. current reporting month transactions only) for reporting against?
Any assistance is appreciated.
Thanks,
Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]
running Worldsoftware A7.3 cume 11
We are experiencing some fairly lengthy run times (sometimes in excess of
2-3 hours) for Worldwriters extracting data from the F0911 file (our F0911
has close to 60 million records). In looking at the joblogs, it appears
that where we have joined the F0911 to another file (e.g. the F0006 to get
BU category code information or BU description, or the F0010 to get current
reporting date and fiscal year), the program zeroes in on the joined fields
as the "keys" for indexing. It also appears that in some cases it cannot
use an existing logical file and creates one (I may be wrong on this
assumption).
The question is, can you define a specific logical file within the
Worldwriter screens? It appears to us that the optimizer scans the logical
files for the "best fit" based on the extraction criteria including joins
within the Worldwriter (again, I may be wrong on this). If so, can we
create our own logical file(s) and specify the appropriate one to be used
with each Worldwriter?
Another related question is, has anyone created "partitions" of their F0911
(e.g. current reporting month transactions only) for reporting against?
Any assistance is appreciated.
Thanks,
Graham G. Aberdein
Clarica
(519) 888-3900 x-4293
email address: [email protected]
running Worldsoftware A7.3 cume 11