Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
TeamSite
TeamSite, LiveSite and OpenDeploy
LSCS Query Time
Migrateduser
Hi All,
We are having external component which will fetch lscs content based on some metadata from dcr.
The problems is,
It is taking 800 ms for query execution when we form the query which will have the "OR" logical operator.
For example:
((TeamSite/Templating/DCR/Type:="Portal/products") AND (G11N/Locale:="en_AU") AND ((BusinessCategory:"****") OR (BusinessCategory:"YYY"))).
It is taking 60 ms for query execution when we form the query without the "OR" logical operator .
For example:
((TeamSite/Templating/DCR/Type:="Portal/products") AND (G11N/Locale:="en_AU") AND ((BusinessCategory:"****"))).
As per my requirement, the business category can come from **** or YYY.
Anyone faced this kind of issue?.
Anybody can you suggest how to reframe the query?
Environment:
Interwoven TeamSite 7.3.2.0.0
Runtime in WAS .
Find more posts tagged with
Comments
There are no comments yet