Magic Banana wrote:
> I did not know it was OK to redirect twice the standard input; to avoid
touching the disk I would have created named pipes,
> as in this short (untested) script ...
After spending the intervening time making about 150 joins, combining
eighteen sets of four-month Webalizer data every which
way, I see that your suspicions may be well founded. The smaller output files
(30 to several hundred kB) are clean-looking,
but the largest ones (1500 kB down to ~700 kB) have duplicated rows, nearly
exclusively. They'll have to have the duplicates
removed during post-processing ... and be checked for errors.
Before I start that processing, I'll see if I can try out your script; the
extra steps won't be any drag on the joining,
as the longest times for any joins were still in the blink-of-an-eye category
(0.044 sec. system time).
I've been pairing up the most recent data with all of the prior data, one
pair at a time, and that's getting tedious. The
"info join" page says that one of the target fields (but not both !) can be
read from standard input. In these repetitive
joins that I'm doing now, can one of the target fields be read from a file
that lists the other target files ? I've got
fifteen more sets of data, so this file list can grow ... up to thirty-two
now, but almost without end if one looks at the
number of Webalizer data sets that are available.