Fetch multiple subtree in single query

[geekguy]

Hi all,

Is it possible to fetch all subtree of given nodes in one query ?

Basically, I want to add proper pagination. So I will first query root nodes, limit them and then find subtrees for them.

Is there any batter way to do this rather than this answer ?

[ThisIsMissEm]

I've ended up doing this:

  def self.subtree(tags)
    tags.reduce ({}) do |memo, tag|
      memo[tag] = tag.descendants.arrange
      memo
    end
  end

But it's certainly not a single query (my use case is to select two root nodes of the tree and return them to the user. I may just switch to using two individual calls. Not sure.

[rudph2]

It seems this thread is dead which is a shame. I would really appreciate query optimisation

[kbrock]

@rudph2 do you have an idea how you would implement this?

[dpsk]

Stuck on this too, any ideas?