Reporting

Why does Dashboard slow down after adding appendcols clause?

POR160893
Builder

Hi,

I have a dashboard where one of the panels is generated from a |loadjob command which produces a table.
This part works as normal.
Now, I need to add an extra column onto the panel's table and as a result, I need to incorporate another index onto the panel's query. As result, the panel's query has both the |loadjob and also an appendcols piece that searches an index. 
The extra clause is as follows:

| appendcols [search index=fraud_glassbox sourcetype="gb:sessions"
| stats count as email_count by Global_EmailID_CSH
| eval score_email = case(email_count<2, 40, 1=1, 100) ]



The issue is .... my dashboard SIGNIFICANTLY slows down in how the results are generated on the dashboard.
Why would this be? Would I need an alterative to appendcols command?

Many thanks,

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It probably slows down because you are doing an additional search - if you are using load job for the first part of the search, have you considered using load job for the appendcols part of the search too?

Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...