Created a django app to display some transaction history detail in a tabular format.
But when the template is accessed from the UI it takes almost 20-25 minutes for displaying search query result. Need help in improving performance of the search query and Django template.
Here is saved search code for reference.
[top_zip_by_amount]
alert.digest_mode = True
alert.suppress = 0
alert.track = 0
cron_schedule = 1 * * * * *
enableSched = 1
search = index=transaction_history |
spath input=Item |
rename HistoryItem.a:TransactionDetails.a:StoreId AS StoreNumber, HistoryItem.a:TotalAmount AS Amount |
fields StoreNumber,Amount |
lookup store_location StoreNumber as StoreNumber OUTPUT PostalCode |
table PostalCode StoreNumber Amount|
stats Sum(Amount) as Total1 count(StoreNumber) as TransactionCount by PostalCode StoreNumber|
fields PostalCode,StoreNumber,TransactionCount, Total1|
stats count(StoreNumber) as StoreCount sum(Total1) as TotalAmount by PostalCode|
fields PostalCode,StoreCount,TotalAmount|
sort TotalAmount desc
Anyone who can guide me on this ?
Thanks!
... View more