Is there a guide indicating what's a complex query for RRC to run and what's not?
I'm on RRC 4.0.6 and trying to run a query against my artifacts.
My criteria are:
Tags not all of <4 different tags out of a total of 32 tags we use>
Type <1 type out of a total of 16 types we use>
My columns are:
ID
Name
Primary Text
Tags
Link From
Satisfies
This should return around 30 artifacts out of around 450 total.
However, every time I try to run it, I get an error indicating it took to long and the search is not completed.
It doesn't look to me like it's that complex a query that should yield that error, but I have hard time judging if the issue is on my server architecture/set up or if it's a problem with RRC itself.
Is there some sort of documentation indicating what are the limitations or not-recommended combinations to run queries for artifacts?
My criteria are:
Tags not all of <4 different tags out of a total of 32 tags we use>
Type <1 type out of a total of 16 types we use>
My columns are:
ID
Name
Primary Text
Tags
Link From
Satisfies
This should return around 30 artifacts out of around 450 total.
However, every time I try to run it, I get an error indicating it took to long and the search is not completed.
It doesn't look to me like it's that complex a query that should yield that error, but I have hard time judging if the issue is on my server architecture/set up or if it's a problem with RRC itself.
Is there some sort of documentation indicating what are the limitations or not-recommended combinations to run queries for artifacts?
Accepted answer
I'm not aware of any documentation along the lines of what you're looking for. That said, there are some known issues with the performance of certain view queries which could be impacting you.
These work items are potential candidates:
Certain view queries with sophisticated link patterns / parameters poorly perform (86748)
Query to determine whether resource has OSLC link is poor performing (89899)
These work items are potential candidates:
Certain view queries with sophisticated link patterns / parameters poorly perform (86748)
Query to determine whether resource has OSLC link is poor performing (89899)
Comments
Both WIs seem to have been fixed as part of 5.0 efforts. I'll wait until we can get the server updated to try and run the same query again to be able to compare performance and assess whether the server architecture requires changes or not.
Thanks!
(I still think there should be official documentation on this to help projects make that assessment)
2 other answers
I'd be interested to know if this is actually a defect fixed in 5.0.1:
https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=314449
You can set "Maximum number of terms that a field in a Lucene document can contain" to -1 in the Advanced Properties of the JTS Admin interface.
Comment 3 also states the errors in the log you might be experiencing. I see you've accepted Stef's answer already, but if you are able to check this, that'd be great.
https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=314449
You can set "Maximum number of terms that a field in a Lucene document can contain" to -1 in the Advanced Properties of the JTS Admin interface.
Comment 3 also states the errors in the log you might be experiencing. I see you've accepted Stef's answer already, but if you are able to check this, that'd be great.
Comments
Donald Nong
Aug 08 '14, 12:03 a.m.This does not sound right if the total number of 450 is for the entire RRC system (not just the particular project area). Such a query should return the result within a second. If your RRC system has much more artifacts than that, you may get a performance issue and you need to do some tuning.
Taly Hotimsky
Aug 08 '14, 9:14 a.m.That's for the particular PA only.
There are many more PAs in the same server (I don't know how many artifacts total)