Splunk Search

Is there a difference in efficiency between this sort and reverse?

yuanliu
SplunkTrust
SplunkTrust

Delta cites an example using sort - _time.

Is there a difference in efficiency between this sort and reverse?

1 Solution

woodcock
Esteemed Legend

Using reverse should be much more effiicient because it just rewrites the list whereas sort must continuously compare values. It should be sort 0 + _time.

View solution in original post

0 Karma

aberkow
Builder

If you look into the job inspector, you should be able to see the runtime and other diagnostic information for your case as well!

0 Karma

to4kawa
Ultra Champion

When I examine it, sort takes more time.

Also, reverse is a command that reverses the log order, so if the time series is disjoint, reverse it.
This is also different from sort .

0 Karma

woodcock
Esteemed Legend

Using reverse should be much more effiicient because it just rewrites the list whereas sort must continuously compare values. It should be sort 0 + _time.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...