in reply to Re^3: Speed up file write taking weeks
in thread Speed up file write taking weeks

Summarise based on another field

Replies are listed 'Best First'.
Re^5: Speed up file write taking weeks
by Marshall (Canon) on Nov 30, 2019 at 01:46 UTC
    It is plausible to have 2 tables, one with 65 million records and one with 72 million records and, generate a resulting table of 100 million records without having to build a multi-trillion line intermediate table.