- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I have a lookup file which takes some time to load (Look up has 19Lakhs data) - This lookup is used in a dashboard
So, we are planning to move with KV store, and created one.
How do I get the exact time taken to load the lookup and the time taken to load the kvstore?
Is there any command to capture the time taken to load the lookup and the KVstore?
In job inspector is there any field?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @VijaySrrie,
You just need to search both the CSV and KVStore lookups with inputlookup command separately.
Once the search is completed. You can click on Job dropdown below the search bar. Click on Inspect Job and you'll see the first line in the Search job inspector page as below.
This search has completed and has returned 23,448 results by scanning 5,862 events in 0.728 seconds.
You can compare the time taken for both the lookups to load.
If this reply helps you, a like would be appreciated.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @VijaySrrie,
You just need to search both the CSV and KVStore lookups with inputlookup command separately.
Once the search is completed. You can click on Job dropdown below the search bar. Click on Inspect Job and you'll see the first line in the Search job inspector page as below.
This search has completed and has returned 23,448 results by scanning 5,862 events in 0.728 seconds.
You can compare the time taken for both the lookups to load.
If this reply helps you, a like would be appreciated.
