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!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...