Re^3: Perl Script performance issue

ACCT NUMBER read main file, second column in main file is primary key for looking up positionfile.delim.

If value is held in 6th column, which column in positionfile.delim is the primary key. Is is column 1 ?

Which column in main file are these held, they can't all be the second column, or am I missing something ?

ACCT NUMBER|positionfile.delim|2|6 
PO TYPE|positionfile.delim|2|3
LOC CODE|positionfile.delim|2|47
[download]

poj

Comment on Re^3: Perl Script performance issue Select or Download Code

Replies are listed 'Best First'.
Re^4: Perl Script performance issue by Tara (Initiate) on Dec 16, 2015 at 08:56 UTC
primary key can be same for many fields. For example: here second column would be acct number 1234, so in order to fetch details for that acct only, i am grepping that acct number (which returns single record) and then select columns as specified. Here LOC CODE\|positionfile.delim\|2\|47 LOC NAME\|locationfile.delim\|47\|4 For loc code, use second column from main file as primary key for looking up positionfile.delim, get 47th field. For loc name, 47th column from main file is primary key for looking up locationfile.delim, get the 4th field.	[reply]
Re^5: Perl Script performance issue by poj (Abbot) on Dec 16, 2015 at 09:05 UTC
For loc code, use second column from main file So in `positionfile.delim` one record provides 3 fields with the same key from column 2 of main file `Column Field 6 ACCT NUMBER\| 3 PO TYPE 47 LOC CODE` [download] Is the key always column 1 in the 3 lookup files `positionfile.delim,accountfile.delim and securityfile.delim` ? How many records in the main file ? Update : Try this. Opening the files just once and caching the search results might improve performance. Read more... (3 kB) poj	[reply] [d/l] [select]