Jira (PDB-1977) Add support for multi-queries

[Karel Brezina (JIRA)]

Karel Brezina created an issue

PuppetDB / PDB-1977 Add support for multi-queries Issue Type: New Feature Assignee: Unassigned Created: 2015/09/17 6:46 AM Priority: Normal Reporter: Karel Brezina Overview page in PE displays a paginated list of nodes and counts of nodes in individual statuses. Currently, all nodes have to be fetched to be able to provide the counts and a few nodes for one page. It would be much better to get the counts and the paginated list directly from PDB. For that a multi-query support is needed since these queries need to be executed in a single transaction. Add Comment

This message was sent by Atlassian JIRA (v6.4.11#64026-sha1:78f6ec4)

[Kenneth Barber (JIRA)]

Kenneth Barber commented on PDB-1977

Re: Add support for multi-queries Karel Brezina just to be clear, you're not worried that pagination results much change from query to query are you? Because that's a harder problem to solve. I presume as long as the count/summary results for query 1, and say the 10 node items for query 2 requested represent the same universe at query time, this would be sufficient.

Add Comment

[Karel Brezina (JIRA)]

Karel Brezina commented on PDB-1977

Re: Add support for multi-queries

Kenneth Barber Right. Currently, nodes are ordered by report_timestamp in descending order. So, it's natural that two subsequent node queries return different list of nodes.

Add Comment

[Karel Brezina (JIRA)]

Karel Brezina commented on PDB-1977

Re: Add support for multi-queries

@ken PDB-1967 needs to be fixed first because it can affect this issue.

Add Comment

[Kenneth Barber (JIRA)]

Kenneth Barber commented on PDB-1977

Re: Add support for multi-queries

Karel Brezina I'm no longer clear if this is urgent or not, you say this is dependant on PDB-1967, but the comments on that one do not make any sense after the discussion we had the other day. Is this still something you need soonish? /cc Scott Walker

Add Comment

[Kenneth Barber (JIRA)]

Kenneth Barber updated an issue

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Kenneth Barber Sprint: PuppetDB 2015-10-21

Add Comment

[Kenneth Barber (JIRA)]

Kenneth Barber updated an issue

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Kenneth Barber Sprint: PuppetDB 2015- 10 11 - 21 4

Add Comment

[Karel Brezina (JIRA)]

Karel Brezina commented on PDB-1977

Re: Add support for multi-queries

Kenneth Barber It's hard to define urgent. I've recorded a video with 4500 nodes - https://drive.google.com/a/puppetlabs.com/file/d/0B7Fpe9nzOKBXY3F3OGRwNVltdTQ/view?usp=sharing . Please, watch the first part - Overview. Loading and navigation between pages is slow. Once, PDB-1967 and PDB-1977 is implemented, the response times should be several times faster. Currently, to be able to display a few nodes for the page and node counts we need to fetch all nodes and the latest reports for all nodes.

Add Comment

[Kenneth Barber (JIRA)]

Kenneth Barber assigned an issue to Beth Cornils

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Kenneth Barber Assignee: Beth Cornils

Add Comment

[Susan McNerney (JIRA)]

Susan McNerney updated an issue

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Susan McNerney Sprint: PuppetDB 2015- 11 10 - 4 21

Add Comment

[Susan McNerney (JIRA)]

Susan McNerney updated an issue

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Susan McNerney Sprint: PuppetDB 2015-10-21

Add Comment

[Scott Walker (JIRA)]

Scott Walker commented on PDB-1977

Re: Add support for multi-queries

Kenneth Barber Beth flagged this up yesterday and my feeling was that we should park this ticket and go with the plan to articulate our problems/concerns directly rather than proposing solutions. We'll do that as a matter of urgency. Karel Brezina

Add Comment

[Kenneth Barber (JIRA)]

Kenneth Barber commented on PDB-1977

Re: Add support for multi-queries

Scott Walker thanks, looking forward to it. I was doing planning, so I wanted to get impressions to see if we needed to consider it this sprint. If you get us before the next two week sprint, we can put it into sprint planning then .

Add Comment

[Claudia Petty (Jira)]

Claudia Petty updated an issue

PuppetDB / PDB-1977 Add support for multi-queries

Change By: Claudia Petty Labels: new-feature

Add Comment

This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8)