Re: [PERFORM] Help with optimizing a query over hierarchical data

2014-03-01 Thread Claudio Freire
On Fri, Feb 28, 2014 at 5:01 PM, Damon Snyder wrote: > The primary query that I'm trying to optimize executes in about 1600ms on my > laptop and about 800ms on production-like hardware (more for the score > version). My target is to get the data fetch down below 100ms if possible. Could you post

[PERFORM] Help with optimizing a query over hierarchical data

2014-03-01 Thread Damon Snyder
Hi Everyone, We have a data set and access pattern that is causing us some performance issues. The data set is hierarchical with about 2 million rows at the lowest level (object), followed by 500k at the next level (container) and approximately 10 at the highest level (category). The way the data