[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [p2-dev] query performance

On 2011-08-10 08:12, Mengxin Zhu wrote:
Hi Thomas,

Thank you for analyzing the bottleneck of my query.

RequiredCapability doesn't support 'namespace' member. So I used below query expression for testing,

"$0.traverse(set(), _, { cache, parent | parent.requirements.unique(cache).collect(rc | select(iu | iu ~= rc)).flatten()})"

However the result is amazing. It costs much more time to query the great number of IUs. I updated the document and benchmark spreadsheet listed below. What do you think?

It looks like the query performs sequential scans instead of using indexes. What type of repository is the 'allIUs' it that you're querying? I'm curious because it doesn't seem to be capable of producing indexes.

- thomas