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!

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...