Why is `sed` no op much faster than `awk` in this case

Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am trying to understand some performance issues related to sed and awk, and I did the following experiment,
$ seq 100000 > test
$ yes 'NR==100001print' | head -n 5000 > test.awk
$ yes '100001p;b' | head -n 5000 > test.sed
$ time sed -nf test.sed test
real 0m3.436s
user 0m3.428s
sys 0m0.004s
$ time awk -F@ -f test.awk test
real 0m11.615s
user 0m11.582s
sys 0m0.007s
$ sed --version
sed (GNU sed) 4.5
$ awk --version
GNU Awk 4.2.1, API: 2.0 (GNU MPFR 3.1.6-p2, GNU MP 6.1.2)
Here, since the test file only contains 100000 lines, all the commands in test.sed and test.awk are no-ops. Both programs only need to match the line number with the address (in sed) or NR(in awk) to decide that the command does not need to be executed, but there is still a huge difference in the time cost. Why is it the case? Are there anyone with different versions of sed and awk installed that gives a different result on this test?
Edit:
The results for mawk (as suggested by @mosvy), original-awk(the name for "one true awk" at debian based systems, suggested by @GregA.Woods) and perl are given below,
$ time mawk -F@ -f test.awk test
real 0m5.934s
user 0m5.919s
sys 0m0.004s
$ time original-awk -F@ -f test.awk test
real 0m8.132s
user 0m8.128s
sys 0m0.004s
$ yes 'print if $.==100001;' | head -n 5000 > test.pl
$ time perl -n test.pl test
real 0m33.245s
user 0m33.110s
sys 0m0.019s
$ mawk -W version
mawk 1.3.4 20171017
$ perl --version
This is perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-thread-multi
Replacing -F@ with -F '' does not make observable changes in the case of gawk and mawk. original-awk does not support empty FS.
Edit 2
The test by @mosvy gives different results, 21s for sed and 11s for mawk, see the comment below for details.
awk sed performance
|
show 4 more comments
I am trying to understand some performance issues related to sed and awk, and I did the following experiment,
$ seq 100000 > test
$ yes 'NR==100001print' | head -n 5000 > test.awk
$ yes '100001p;b' | head -n 5000 > test.sed
$ time sed -nf test.sed test
real 0m3.436s
user 0m3.428s
sys 0m0.004s
$ time awk -F@ -f test.awk test
real 0m11.615s
user 0m11.582s
sys 0m0.007s
$ sed --version
sed (GNU sed) 4.5
$ awk --version
GNU Awk 4.2.1, API: 2.0 (GNU MPFR 3.1.6-p2, GNU MP 6.1.2)
Here, since the test file only contains 100000 lines, all the commands in test.sed and test.awk are no-ops. Both programs only need to match the line number with the address (in sed) or NR(in awk) to decide that the command does not need to be executed, but there is still a huge difference in the time cost. Why is it the case? Are there anyone with different versions of sed and awk installed that gives a different result on this test?
Edit:
The results for mawk (as suggested by @mosvy), original-awk(the name for "one true awk" at debian based systems, suggested by @GregA.Woods) and perl are given below,
$ time mawk -F@ -f test.awk test
real 0m5.934s
user 0m5.919s
sys 0m0.004s
$ time original-awk -F@ -f test.awk test
real 0m8.132s
user 0m8.128s
sys 0m0.004s
$ yes 'print if $.==100001;' | head -n 5000 > test.pl
$ time perl -n test.pl test
real 0m33.245s
user 0m33.110s
sys 0m0.019s
$ mawk -W version
mawk 1.3.4 20171017
$ perl --version
This is perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-thread-multi
Replacing -F@ with -F '' does not make observable changes in the case of gawk and mawk. original-awk does not support empty FS.
Edit 2
The test by @mosvy gives different results, 21s for sed and 11s for mawk, see the comment below for details.
awk sed performance
2
I also suggest you try it withmawk;-)
– mosvy
Mar 17 at 23:02
2
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed forGNU awk. SettingFSto empty string seems to causeawkto split each individual character as a field.
– Weijun Zhou
Mar 19 at 6:09
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25
|
show 4 more comments
I am trying to understand some performance issues related to sed and awk, and I did the following experiment,
$ seq 100000 > test
$ yes 'NR==100001print' | head -n 5000 > test.awk
$ yes '100001p;b' | head -n 5000 > test.sed
$ time sed -nf test.sed test
real 0m3.436s
user 0m3.428s
sys 0m0.004s
$ time awk -F@ -f test.awk test
real 0m11.615s
user 0m11.582s
sys 0m0.007s
$ sed --version
sed (GNU sed) 4.5
$ awk --version
GNU Awk 4.2.1, API: 2.0 (GNU MPFR 3.1.6-p2, GNU MP 6.1.2)
Here, since the test file only contains 100000 lines, all the commands in test.sed and test.awk are no-ops. Both programs only need to match the line number with the address (in sed) or NR(in awk) to decide that the command does not need to be executed, but there is still a huge difference in the time cost. Why is it the case? Are there anyone with different versions of sed and awk installed that gives a different result on this test?
Edit:
The results for mawk (as suggested by @mosvy), original-awk(the name for "one true awk" at debian based systems, suggested by @GregA.Woods) and perl are given below,
$ time mawk -F@ -f test.awk test
real 0m5.934s
user 0m5.919s
sys 0m0.004s
$ time original-awk -F@ -f test.awk test
real 0m8.132s
user 0m8.128s
sys 0m0.004s
$ yes 'print if $.==100001;' | head -n 5000 > test.pl
$ time perl -n test.pl test
real 0m33.245s
user 0m33.110s
sys 0m0.019s
$ mawk -W version
mawk 1.3.4 20171017
$ perl --version
This is perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-thread-multi
Replacing -F@ with -F '' does not make observable changes in the case of gawk and mawk. original-awk does not support empty FS.
Edit 2
The test by @mosvy gives different results, 21s for sed and 11s for mawk, see the comment below for details.
awk sed performance
I am trying to understand some performance issues related to sed and awk, and I did the following experiment,
$ seq 100000 > test
$ yes 'NR==100001print' | head -n 5000 > test.awk
$ yes '100001p;b' | head -n 5000 > test.sed
$ time sed -nf test.sed test
real 0m3.436s
user 0m3.428s
sys 0m0.004s
$ time awk -F@ -f test.awk test
real 0m11.615s
user 0m11.582s
sys 0m0.007s
$ sed --version
sed (GNU sed) 4.5
$ awk --version
GNU Awk 4.2.1, API: 2.0 (GNU MPFR 3.1.6-p2, GNU MP 6.1.2)
Here, since the test file only contains 100000 lines, all the commands in test.sed and test.awk are no-ops. Both programs only need to match the line number with the address (in sed) or NR(in awk) to decide that the command does not need to be executed, but there is still a huge difference in the time cost. Why is it the case? Are there anyone with different versions of sed and awk installed that gives a different result on this test?
Edit:
The results for mawk (as suggested by @mosvy), original-awk(the name for "one true awk" at debian based systems, suggested by @GregA.Woods) and perl are given below,
$ time mawk -F@ -f test.awk test
real 0m5.934s
user 0m5.919s
sys 0m0.004s
$ time original-awk -F@ -f test.awk test
real 0m8.132s
user 0m8.128s
sys 0m0.004s
$ yes 'print if $.==100001;' | head -n 5000 > test.pl
$ time perl -n test.pl test
real 0m33.245s
user 0m33.110s
sys 0m0.019s
$ mawk -W version
mawk 1.3.4 20171017
$ perl --version
This is perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-thread-multi
Replacing -F@ with -F '' does not make observable changes in the case of gawk and mawk. original-awk does not support empty FS.
Edit 2
The test by @mosvy gives different results, 21s for sed and 11s for mawk, see the comment below for details.
awk sed performance
awk sed performance
edited Mar 23 at 11:35
Jeff Schaller♦
45k1164147
45k1164147
asked Mar 17 at 22:49
Weijun ZhouWeijun Zhou
1,681427
1,681427
2
I also suggest you try it withmawk;-)
– mosvy
Mar 17 at 23:02
2
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed forGNU awk. SettingFSto empty string seems to causeawkto split each individual character as a field.
– Weijun Zhou
Mar 19 at 6:09
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25
|
show 4 more comments
2
I also suggest you try it withmawk;-)
– mosvy
Mar 17 at 23:02
2
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed forGNU awk. SettingFSto empty string seems to causeawkto split each individual character as a field.
– Weijun Zhou
Mar 19 at 6:09
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25
2
2
I also suggest you try it with
mawk ;-)– mosvy
Mar 17 at 23:02
I also suggest you try it with
mawk ;-)– mosvy
Mar 17 at 23:02
2
2
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed for
GNU awk. Setting FS to empty string seems to cause awk to split each individual character as a field.– Weijun Zhou
Mar 19 at 6:09
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed for
GNU awk. Setting FS to empty string seems to cause awk to split each individual character as a field.– Weijun Zhou
Mar 19 at 6:09
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25
|
show 4 more comments
2 Answers
2
active
oldest
votes
awk has a wider feature set than sed, with a more flexible syntax. So it's not unreasonable that it'll take longer both to parse its scripts, and to execute them.
As your example command (the part inside the braces) never runs, the time-sensitive part should be your test expression.
awk
First, look at the test in the awk example:
NR==100001
and see the effects of that in gprof (GNU awk 4.0.1):
% cumulative self self total
time seconds seconds calls s/call s/call name
55.89 19.73 19.73 1 19.73 35.04 interpret
8.90 22.87 3.14 500000000 0.00 0.00 cmp_scalar
8.64 25.92 3.05 1000305023 0.00 0.00 free_wstr
8.61 28.96 3.04 500105014 0.00 0.00 mk_number
6.09 31.11 2.15 500000001 0.00 0.00 cmp_nodes
4.18 32.59 1.48 500200013 0.00 0.00 unref
3.68 33.89 1.30 500000000 0.00 0.00 eval_condition
2.21 34.67 0.78 500000000 0.00 0.00 update_NR
~50% of the time is spent in "interpret", the top-level loop to run the opcodes resulting from the parsed script.
Every time the test is run (ie. 5000 script lines * 100000 input lines), awk has to:
- Fetch the built-in variable "NR" (
update_NR). - Convert the string "100001" (
mk_number). - Compare them (
cmp_nodes,cmp_scalar,eval_condition). - Discard any temporary objects needed for the comparison (
free_wstr,unref)
Other awk implementations won't have the exact same call flow, but they will still have to retrieve variables, automatically convert, then compare.
sed
By comparison, in sed, the "test" is much more limited. It can only be a single address, an address range, or nothing (when the command is the first thing on the line), and sed can tell from the first character whether it's an address or command. In the example, it's
100001
...a single numerical address. The profile (GNU sed 4.2.2) shows
% cumulative self self total
time seconds seconds calls s/call s/call name
52.01 2.98 2.98 100000 0.00 0.00 execute_program
44.16 5.51 2.53 1000000000 0.00 0.00 match_address_p
3.84 5.73 0.22 match_an_address_p
[...]
0.00 5.73 0.00 5000 0.00 0.00 in_integer
Again, ~50% of the time is in the top-level execute_program. In this case, it's called once per input line, then loops over the parsed commands. The loop starts with an address check, but that's not all it does in your example (see later).
The line numbers in the input script were parsed at compile-time (in_integer). That only has to be done once for each address number in the input, ie. 5000 times, and doesn't make a significant contribution to the overall running time.
That means that the address check, match_address_p, only compares integers that are already available (through structs and pointers).
further sed improvements
The profile shows that match_address_p is called 2*5000*100000 times, ie. twice per script-line*input-line. This is because, behind the scenes, GNU sed treats the "start block" command
100001...
as a negated branch to the end of the block
100001!b end; ... :end
This address match succeeds on every input line, causing a branch to the end of the block (}). That block-end has no associated address, so it's another successful match. That explains why so much time is spent in execute_program.
So that sed expression would be even faster if it omitted the unused ;b, and the resulting unnecessary ..., leaving only 100001p.
% cumulative self self total
time seconds seconds calls s/call s/call name
71.43 1.40 1.40 500000000 0.00 0.00 match_address_p
24.49 1.88 0.48 100000 0.00 0.00 execute_program
4.08 1.96 0.08 match_an_address_p
That halves the number of match_address_p calls, and also cuts most of the time spent in execute_program (because the address match never succeeds).
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
@Tagwint I recompiledawkandsedwith profiling enabled, then usedgprof(part of binutils). Though the large numbers meant I had to realign the columns manually.
– JigglyNaga
Mar 19 at 18:04
add a comment |
Actually the above script is not a noop for awk:
Even if you do not use the contents of the fields, according to GAWK manual for each record that is read in the following steps are inevitably performed:
- scanning for all occurrences of the FS
- field splitting
- updating th NF variable
If you are not using this information it just gets discarded afterwards.
If a field separator does not occur within the record, awk still has to assign text to $0 (and in your case to $1, too), and set NF to the actual number of obtained fields (1 in the sample above)
2
all that doesn't really make a difference -- trytime gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the$1, ... fields are first used.
– mosvy
Mar 19 at 14:43
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f506892%2fwhy-is-sed-no-op-much-faster-than-awk-in-this-case%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
awk has a wider feature set than sed, with a more flexible syntax. So it's not unreasonable that it'll take longer both to parse its scripts, and to execute them.
As your example command (the part inside the braces) never runs, the time-sensitive part should be your test expression.
awk
First, look at the test in the awk example:
NR==100001
and see the effects of that in gprof (GNU awk 4.0.1):
% cumulative self self total
time seconds seconds calls s/call s/call name
55.89 19.73 19.73 1 19.73 35.04 interpret
8.90 22.87 3.14 500000000 0.00 0.00 cmp_scalar
8.64 25.92 3.05 1000305023 0.00 0.00 free_wstr
8.61 28.96 3.04 500105014 0.00 0.00 mk_number
6.09 31.11 2.15 500000001 0.00 0.00 cmp_nodes
4.18 32.59 1.48 500200013 0.00 0.00 unref
3.68 33.89 1.30 500000000 0.00 0.00 eval_condition
2.21 34.67 0.78 500000000 0.00 0.00 update_NR
~50% of the time is spent in "interpret", the top-level loop to run the opcodes resulting from the parsed script.
Every time the test is run (ie. 5000 script lines * 100000 input lines), awk has to:
- Fetch the built-in variable "NR" (
update_NR). - Convert the string "100001" (
mk_number). - Compare them (
cmp_nodes,cmp_scalar,eval_condition). - Discard any temporary objects needed for the comparison (
free_wstr,unref)
Other awk implementations won't have the exact same call flow, but they will still have to retrieve variables, automatically convert, then compare.
sed
By comparison, in sed, the "test" is much more limited. It can only be a single address, an address range, or nothing (when the command is the first thing on the line), and sed can tell from the first character whether it's an address or command. In the example, it's
100001
...a single numerical address. The profile (GNU sed 4.2.2) shows
% cumulative self self total
time seconds seconds calls s/call s/call name
52.01 2.98 2.98 100000 0.00 0.00 execute_program
44.16 5.51 2.53 1000000000 0.00 0.00 match_address_p
3.84 5.73 0.22 match_an_address_p
[...]
0.00 5.73 0.00 5000 0.00 0.00 in_integer
Again, ~50% of the time is in the top-level execute_program. In this case, it's called once per input line, then loops over the parsed commands. The loop starts with an address check, but that's not all it does in your example (see later).
The line numbers in the input script were parsed at compile-time (in_integer). That only has to be done once for each address number in the input, ie. 5000 times, and doesn't make a significant contribution to the overall running time.
That means that the address check, match_address_p, only compares integers that are already available (through structs and pointers).
further sed improvements
The profile shows that match_address_p is called 2*5000*100000 times, ie. twice per script-line*input-line. This is because, behind the scenes, GNU sed treats the "start block" command
100001...
as a negated branch to the end of the block
100001!b end; ... :end
This address match succeeds on every input line, causing a branch to the end of the block (}). That block-end has no associated address, so it's another successful match. That explains why so much time is spent in execute_program.
So that sed expression would be even faster if it omitted the unused ;b, and the resulting unnecessary ..., leaving only 100001p.
% cumulative self self total
time seconds seconds calls s/call s/call name
71.43 1.40 1.40 500000000 0.00 0.00 match_address_p
24.49 1.88 0.48 100000 0.00 0.00 execute_program
4.08 1.96 0.08 match_an_address_p
That halves the number of match_address_p calls, and also cuts most of the time spent in execute_program (because the address match never succeeds).
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
@Tagwint I recompiledawkandsedwith profiling enabled, then usedgprof(part of binutils). Though the large numbers meant I had to realign the columns manually.
– JigglyNaga
Mar 19 at 18:04
add a comment |
awk has a wider feature set than sed, with a more flexible syntax. So it's not unreasonable that it'll take longer both to parse its scripts, and to execute them.
As your example command (the part inside the braces) never runs, the time-sensitive part should be your test expression.
awk
First, look at the test in the awk example:
NR==100001
and see the effects of that in gprof (GNU awk 4.0.1):
% cumulative self self total
time seconds seconds calls s/call s/call name
55.89 19.73 19.73 1 19.73 35.04 interpret
8.90 22.87 3.14 500000000 0.00 0.00 cmp_scalar
8.64 25.92 3.05 1000305023 0.00 0.00 free_wstr
8.61 28.96 3.04 500105014 0.00 0.00 mk_number
6.09 31.11 2.15 500000001 0.00 0.00 cmp_nodes
4.18 32.59 1.48 500200013 0.00 0.00 unref
3.68 33.89 1.30 500000000 0.00 0.00 eval_condition
2.21 34.67 0.78 500000000 0.00 0.00 update_NR
~50% of the time is spent in "interpret", the top-level loop to run the opcodes resulting from the parsed script.
Every time the test is run (ie. 5000 script lines * 100000 input lines), awk has to:
- Fetch the built-in variable "NR" (
update_NR). - Convert the string "100001" (
mk_number). - Compare them (
cmp_nodes,cmp_scalar,eval_condition). - Discard any temporary objects needed for the comparison (
free_wstr,unref)
Other awk implementations won't have the exact same call flow, but they will still have to retrieve variables, automatically convert, then compare.
sed
By comparison, in sed, the "test" is much more limited. It can only be a single address, an address range, or nothing (when the command is the first thing on the line), and sed can tell from the first character whether it's an address or command. In the example, it's
100001
...a single numerical address. The profile (GNU sed 4.2.2) shows
% cumulative self self total
time seconds seconds calls s/call s/call name
52.01 2.98 2.98 100000 0.00 0.00 execute_program
44.16 5.51 2.53 1000000000 0.00 0.00 match_address_p
3.84 5.73 0.22 match_an_address_p
[...]
0.00 5.73 0.00 5000 0.00 0.00 in_integer
Again, ~50% of the time is in the top-level execute_program. In this case, it's called once per input line, then loops over the parsed commands. The loop starts with an address check, but that's not all it does in your example (see later).
The line numbers in the input script were parsed at compile-time (in_integer). That only has to be done once for each address number in the input, ie. 5000 times, and doesn't make a significant contribution to the overall running time.
That means that the address check, match_address_p, only compares integers that are already available (through structs and pointers).
further sed improvements
The profile shows that match_address_p is called 2*5000*100000 times, ie. twice per script-line*input-line. This is because, behind the scenes, GNU sed treats the "start block" command
100001...
as a negated branch to the end of the block
100001!b end; ... :end
This address match succeeds on every input line, causing a branch to the end of the block (}). That block-end has no associated address, so it's another successful match. That explains why so much time is spent in execute_program.
So that sed expression would be even faster if it omitted the unused ;b, and the resulting unnecessary ..., leaving only 100001p.
% cumulative self self total
time seconds seconds calls s/call s/call name
71.43 1.40 1.40 500000000 0.00 0.00 match_address_p
24.49 1.88 0.48 100000 0.00 0.00 execute_program
4.08 1.96 0.08 match_an_address_p
That halves the number of match_address_p calls, and also cuts most of the time spent in execute_program (because the address match never succeeds).
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
@Tagwint I recompiledawkandsedwith profiling enabled, then usedgprof(part of binutils). Though the large numbers meant I had to realign the columns manually.
– JigglyNaga
Mar 19 at 18:04
add a comment |
awk has a wider feature set than sed, with a more flexible syntax. So it's not unreasonable that it'll take longer both to parse its scripts, and to execute them.
As your example command (the part inside the braces) never runs, the time-sensitive part should be your test expression.
awk
First, look at the test in the awk example:
NR==100001
and see the effects of that in gprof (GNU awk 4.0.1):
% cumulative self self total
time seconds seconds calls s/call s/call name
55.89 19.73 19.73 1 19.73 35.04 interpret
8.90 22.87 3.14 500000000 0.00 0.00 cmp_scalar
8.64 25.92 3.05 1000305023 0.00 0.00 free_wstr
8.61 28.96 3.04 500105014 0.00 0.00 mk_number
6.09 31.11 2.15 500000001 0.00 0.00 cmp_nodes
4.18 32.59 1.48 500200013 0.00 0.00 unref
3.68 33.89 1.30 500000000 0.00 0.00 eval_condition
2.21 34.67 0.78 500000000 0.00 0.00 update_NR
~50% of the time is spent in "interpret", the top-level loop to run the opcodes resulting from the parsed script.
Every time the test is run (ie. 5000 script lines * 100000 input lines), awk has to:
- Fetch the built-in variable "NR" (
update_NR). - Convert the string "100001" (
mk_number). - Compare them (
cmp_nodes,cmp_scalar,eval_condition). - Discard any temporary objects needed for the comparison (
free_wstr,unref)
Other awk implementations won't have the exact same call flow, but they will still have to retrieve variables, automatically convert, then compare.
sed
By comparison, in sed, the "test" is much more limited. It can only be a single address, an address range, or nothing (when the command is the first thing on the line), and sed can tell from the first character whether it's an address or command. In the example, it's
100001
...a single numerical address. The profile (GNU sed 4.2.2) shows
% cumulative self self total
time seconds seconds calls s/call s/call name
52.01 2.98 2.98 100000 0.00 0.00 execute_program
44.16 5.51 2.53 1000000000 0.00 0.00 match_address_p
3.84 5.73 0.22 match_an_address_p
[...]
0.00 5.73 0.00 5000 0.00 0.00 in_integer
Again, ~50% of the time is in the top-level execute_program. In this case, it's called once per input line, then loops over the parsed commands. The loop starts with an address check, but that's not all it does in your example (see later).
The line numbers in the input script were parsed at compile-time (in_integer). That only has to be done once for each address number in the input, ie. 5000 times, and doesn't make a significant contribution to the overall running time.
That means that the address check, match_address_p, only compares integers that are already available (through structs and pointers).
further sed improvements
The profile shows that match_address_p is called 2*5000*100000 times, ie. twice per script-line*input-line. This is because, behind the scenes, GNU sed treats the "start block" command
100001...
as a negated branch to the end of the block
100001!b end; ... :end
This address match succeeds on every input line, causing a branch to the end of the block (}). That block-end has no associated address, so it's another successful match. That explains why so much time is spent in execute_program.
So that sed expression would be even faster if it omitted the unused ;b, and the resulting unnecessary ..., leaving only 100001p.
% cumulative self self total
time seconds seconds calls s/call s/call name
71.43 1.40 1.40 500000000 0.00 0.00 match_address_p
24.49 1.88 0.48 100000 0.00 0.00 execute_program
4.08 1.96 0.08 match_an_address_p
That halves the number of match_address_p calls, and also cuts most of the time spent in execute_program (because the address match never succeeds).
awk has a wider feature set than sed, with a more flexible syntax. So it's not unreasonable that it'll take longer both to parse its scripts, and to execute them.
As your example command (the part inside the braces) never runs, the time-sensitive part should be your test expression.
awk
First, look at the test in the awk example:
NR==100001
and see the effects of that in gprof (GNU awk 4.0.1):
% cumulative self self total
time seconds seconds calls s/call s/call name
55.89 19.73 19.73 1 19.73 35.04 interpret
8.90 22.87 3.14 500000000 0.00 0.00 cmp_scalar
8.64 25.92 3.05 1000305023 0.00 0.00 free_wstr
8.61 28.96 3.04 500105014 0.00 0.00 mk_number
6.09 31.11 2.15 500000001 0.00 0.00 cmp_nodes
4.18 32.59 1.48 500200013 0.00 0.00 unref
3.68 33.89 1.30 500000000 0.00 0.00 eval_condition
2.21 34.67 0.78 500000000 0.00 0.00 update_NR
~50% of the time is spent in "interpret", the top-level loop to run the opcodes resulting from the parsed script.
Every time the test is run (ie. 5000 script lines * 100000 input lines), awk has to:
- Fetch the built-in variable "NR" (
update_NR). - Convert the string "100001" (
mk_number). - Compare them (
cmp_nodes,cmp_scalar,eval_condition). - Discard any temporary objects needed for the comparison (
free_wstr,unref)
Other awk implementations won't have the exact same call flow, but they will still have to retrieve variables, automatically convert, then compare.
sed
By comparison, in sed, the "test" is much more limited. It can only be a single address, an address range, or nothing (when the command is the first thing on the line), and sed can tell from the first character whether it's an address or command. In the example, it's
100001
...a single numerical address. The profile (GNU sed 4.2.2) shows
% cumulative self self total
time seconds seconds calls s/call s/call name
52.01 2.98 2.98 100000 0.00 0.00 execute_program
44.16 5.51 2.53 1000000000 0.00 0.00 match_address_p
3.84 5.73 0.22 match_an_address_p
[...]
0.00 5.73 0.00 5000 0.00 0.00 in_integer
Again, ~50% of the time is in the top-level execute_program. In this case, it's called once per input line, then loops over the parsed commands. The loop starts with an address check, but that's not all it does in your example (see later).
The line numbers in the input script were parsed at compile-time (in_integer). That only has to be done once for each address number in the input, ie. 5000 times, and doesn't make a significant contribution to the overall running time.
That means that the address check, match_address_p, only compares integers that are already available (through structs and pointers).
further sed improvements
The profile shows that match_address_p is called 2*5000*100000 times, ie. twice per script-line*input-line. This is because, behind the scenes, GNU sed treats the "start block" command
100001...
as a negated branch to the end of the block
100001!b end; ... :end
This address match succeeds on every input line, causing a branch to the end of the block (}). That block-end has no associated address, so it's another successful match. That explains why so much time is spent in execute_program.
So that sed expression would be even faster if it omitted the unused ;b, and the resulting unnecessary ..., leaving only 100001p.
% cumulative self self total
time seconds seconds calls s/call s/call name
71.43 1.40 1.40 500000000 0.00 0.00 match_address_p
24.49 1.88 0.48 100000 0.00 0.00 execute_program
4.08 1.96 0.08 match_an_address_p
That halves the number of match_address_p calls, and also cuts most of the time spent in execute_program (because the address match never succeeds).
edited Mar 20 at 16:59
answered Mar 19 at 17:08
JigglyNagaJigglyNaga
4,0621035
4,0621035
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
@Tagwint I recompiledawkandsedwith profiling enabled, then usedgprof(part of binutils). Though the large numbers meant I had to realign the columns manually.
– JigglyNaga
Mar 19 at 18:04
add a comment |
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
@Tagwint I recompiledawkandsedwith profiling enabled, then usedgprof(part of binutils). Though the large numbers meant I had to realign the columns manually.
– JigglyNaga
Mar 19 at 18:04
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
JiggilyNaga, what was the command to get the output like that, please?
– Tagwint
Mar 19 at 17:42
1
1
@Tagwint I recompiled
awk and sed with profiling enabled, then used gprof (part of binutils). Though the large numbers meant I had to realign the columns manually.– JigglyNaga
Mar 19 at 18:04
@Tagwint I recompiled
awk and sed with profiling enabled, then used gprof (part of binutils). Though the large numbers meant I had to realign the columns manually.– JigglyNaga
Mar 19 at 18:04
add a comment |
Actually the above script is not a noop for awk:
Even if you do not use the contents of the fields, according to GAWK manual for each record that is read in the following steps are inevitably performed:
- scanning for all occurrences of the FS
- field splitting
- updating th NF variable
If you are not using this information it just gets discarded afterwards.
If a field separator does not occur within the record, awk still has to assign text to $0 (and in your case to $1, too), and set NF to the actual number of obtained fields (1 in the sample above)
2
all that doesn't really make a difference -- trytime gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the$1, ... fields are first used.
– mosvy
Mar 19 at 14:43
add a comment |
Actually the above script is not a noop for awk:
Even if you do not use the contents of the fields, according to GAWK manual for each record that is read in the following steps are inevitably performed:
- scanning for all occurrences of the FS
- field splitting
- updating th NF variable
If you are not using this information it just gets discarded afterwards.
If a field separator does not occur within the record, awk still has to assign text to $0 (and in your case to $1, too), and set NF to the actual number of obtained fields (1 in the sample above)
2
all that doesn't really make a difference -- trytime gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the$1, ... fields are first used.
– mosvy
Mar 19 at 14:43
add a comment |
Actually the above script is not a noop for awk:
Even if you do not use the contents of the fields, according to GAWK manual for each record that is read in the following steps are inevitably performed:
- scanning for all occurrences of the FS
- field splitting
- updating th NF variable
If you are not using this information it just gets discarded afterwards.
If a field separator does not occur within the record, awk still has to assign text to $0 (and in your case to $1, too), and set NF to the actual number of obtained fields (1 in the sample above)
Actually the above script is not a noop for awk:
Even if you do not use the contents of the fields, according to GAWK manual for each record that is read in the following steps are inevitably performed:
- scanning for all occurrences of the FS
- field splitting
- updating th NF variable
If you are not using this information it just gets discarded afterwards.
If a field separator does not occur within the record, awk still has to assign text to $0 (and in your case to $1, too), and set NF to the actual number of obtained fields (1 in the sample above)
edited Mar 19 at 14:42
answered Mar 19 at 14:35
jf1jf1
1745
1745
2
all that doesn't really make a difference -- trytime gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the$1, ... fields are first used.
– mosvy
Mar 19 at 14:43
add a comment |
2
all that doesn't really make a difference -- trytime gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the$1, ... fields are first used.
– mosvy
Mar 19 at 14:43
2
2
all that doesn't really make a difference -- try
time gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the $1, ... fields are first used.– mosvy
Mar 19 at 14:43
all that doesn't really make a difference -- try
time gawk '$1=$1+$1' test >/dev/null; it's really the big unrealistic script that's blowing it up. Also notice that (at least the original awk) does not do splitting until the $1, ... fields are first used.– mosvy
Mar 19 at 14:43
add a comment |
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f506892%2fwhy-is-sed-no-op-much-faster-than-awk-in-this-case%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
I also suggest you try it with
mawk;-)– mosvy
Mar 17 at 23:02
2
Without any testing, I wonder if awk is doing more work per line because of the -F@ field splitting.
– Jeff Schaller♦
Mar 18 at 1:24
One should always test Awk performance and compatability against The One True Awk. github.com/onetrueawk/awk
– Greg A. Woods
Mar 19 at 0:23
@JeffSchaller I try to figure out a way so that awk does not do any field splitting at all, but at least failed for
GNU awk. SettingFSto empty string seems to causeawkto split each individual character as a field.– Weijun Zhou
Mar 19 at 6:09
@GregA.Woods Updated.
– Weijun Zhou
Mar 19 at 12:25