Jira (PDB-5224) Investigate query performance for "CD4PE - code manager resource"

2021-10-05 Thread Nick Walker (Jira)
Title: Message Title


 
 
 
 

 
 
 

 
   
 Nick Walker commented on  PDB-5224  
 

  
 
 
 
 

 
 
  
 
 
 
 

 
  Re: Investigate query performance for "CD4PE - code manager resource"   
 

  
 
 
 
 

 
 Eric Williamson or Chris Leicester do you know why we are looking for the results of this query? It is apparently pretty slow and I'm wondering if we can get this info another way.   
 

  
 
 
 
 

 
 
 

 
 
 Add Comment  
 

  
 

  
 
 
 
  
 

  
 
 
 
 

 
 This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)  
 
 

 
   
 

  
 

  
 

   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.409157.1627566387000.147148.1633445520053%40Atlassian.JIRA.


Jira (PDB-5224) Investigate query performance for "CD4PE - code manager resource"

2021-07-29 Thread Bogdan Irimie (Jira)
Title: Message Title


 
 
 
 

 
 
 

 
   
 Bogdan Irimie updated an issue  
 

  
 
 
 
 

 
 
  
 
 
 
 

 
 PuppetDB /  PDB-5224  
 
 
  Investigate query performance for "CD4PE - code manager resource"   
 

  
 
 
 
 

 
Change By: 
 Bogdan Irimie  
 
 
Priority: 
 Normal Low  
 

  
 
 
 
 

 
 
 

 
 
 Add Comment  
 

  
 

  
 
 
 
  
 

  
 
 
 
 

 
 This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)  
 
 

 
   
 

  
 

  
 

   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.409157.1627566387000.93918.1627566540476%40Atlassian.JIRA.


Jira (PDB-5224) Investigate query performance for "CD4PE - code manager resource"

2021-07-29 Thread Bogdan Irimie (Jira)
Title: Message Title


 
 
 
 

 
 
 

 
   
 Bogdan Irimie created an issue  
 

  
 
 
 
 

 
 
  
 
 
 
 

 
 PuppetDB /  PDB-5224  
 
 
  Investigate query performance for "CD4PE - code manager resource"   
 

  
 
 
 
 

 
Issue Type: 
  Task  
 
 
Assignee: 
 Unassigned  
 
 
Created: 
 2021/07/29 6:46 AM  
 
 
Priority: 
  Normal  
 
 
Reporter: 
 Bogdan Irimie  
 

  
 
 
 
 

 
 From the performance test we ran in https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit?usp=sharing  
 
 
 
 
 curl --location -g --request GET 'http://localhost:8080/pdb/query/v4/resources?query=["extract",["parameters"],["and",["=","title","Puppet_enterprise::Master::Code_manager"]]]'
  
 
 
 
  is an outlier and we should investigate if this query can be rewritten in a more efficient way or if we can make changes to the query engine in order to improve it's performance  
 

  
 
 
 
 

 
 
 

 
 
 Add Comment