https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145059#M40395 <P>Hello,</P> <P>Are you sure it's the django causing the delays on the page ? </P> <P>Can you try running your search in a non-django environment ? </P> <P>Or maybe split the search into many small parts and start adding them up until you get to the part that makes it all slow down at least that way you would isolate your problem and eventually figure out whats causing all that delay.</P> Mon, 26 May 2014 18:27:35 GMT DavidHourani 2014-05-26T18:27:35Z https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145055#M40391 <P>Created a django app to display some transaction history detail in a tabular format.<BR /> 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.</P> <P>Here is saved search code for reference.<BR /> <CODE><BR /> [top_zip_by_amount]<BR /> alert.digest_mode = True<BR /> alert.suppress = 0<BR /> alert.track = 0<BR /> cron_schedule = 1 * * * * *<BR /> enableSched = 1<BR /> search = index=transaction_history | <BR /> spath input=Item | <BR /> rename HistoryItem.a:TransactionDetails.a:StoreId AS StoreNumber, HistoryItem.a:TotalAmount AS Amount | <BR /> fields StoreNumber,Amount | <BR /> lookup store_location StoreNumber as StoreNumber OUTPUT PostalCode | <BR /> table PostalCode StoreNumber Amount|<BR /> stats Sum(Amount) as Total1 count(StoreNumber) as TransactionCount by PostalCode StoreNumber|<BR /> fields PostalCode,StoreNumber,TransactionCount, Total1|<BR /> stats count(StoreNumber) as StoreCount sum(Total1) as TotalAmount by PostalCode|<BR /> fields PostalCode,StoreCount,TotalAmount|<BR /> sort TotalAmount desc<BR /> </CODE></P> <P>Anyone who can guide me on this ?</P> <P>Thanks!</P> Mon, 28 Sep 2020 16:29:02 GMT https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145055#M40391 vgnulinux 2020-09-28T16:29:02Z https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145056#M40392 <P>First you should check the job inspector for one of those searches to verify if it's the search job being slow or the django-based page rendering slowly.</P> Mon, 28 Apr 2014 19:48:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145056#M40392 martin_mueller 2014-04-28T19:48:50Z https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145057#M40393 <P>thanks martin, your advice to optimize search using search inspector did help us to improve performance of our web page in Django</P> Mon, 26 May 2014 11:43:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145057#M40393 vkalgath 2014-05-26T11:43:07Z https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145058#M40394 <P>Great. Any other issues left?</P> Mon, 26 May 2014 16:12:03 GMT https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145058#M40394 martin_mueller 2014-05-26T16:12:03Z https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145059#M40395 <P>Hello,</P> <P>Are you sure it's the django causing the delays on the page ? </P> <P>Can you try running your search in a non-django environment ? </P> <P>Or maybe split the search into many small parts and start adding them up until you get to the part that makes it all slow down at least that way you would isolate your problem and eventually figure out whats causing all that delay.</P> Mon, 26 May 2014 18:27:35 GMT https://community.splunk.com/t5/Splunk-Search/How-to-improve-django-template-search-performance/m-p/145059#M40395 DavidHourani 2014-05-26T18:27:35Z