Judie,
I assume $resultsLimit is 10?
Can you tell us what the word queries in $searchTermsQ are (particularly any
wildcards or options such as case-sensitive options), and query-meters() output
from:
let $results := cts:search(collection("x"), cts:or-query(($searchTermsQ)))[1 to
10]
return xdmp:query-meters()
? Also running this via the "profile" button in CQ should pinpoint if one query
is slower than the others.
Damon
________________________________
From: [email protected]
[[email protected]] On Behalf Of judie pearline
[[email protected]]
Sent: Friday, April 01, 2011 10:53 AM
To: Clark Richey
Cc: Mark Logic
Subject: Re: [MarkLogic Dev General] Performance improvement
Hi Clark,
Please find the code snippet
let $searchTermsQ := cts-word-queries
let $results1 := cts:search(collection("x"),
cts:and-query((cts:or-query($searchTermsQ))))[1 to $resultsLimit]
let $ results2:= cts:search(collection("y"),
cts:and-query((cts:or-query($searchTermsQ))))[1 to $resultsLimit]
let $ results3:= cts:search(collection("z"),
cts:and-query((cts:or-query($searchTermsQ))))[1 to
$resultsLimit]
.
.
.
.
.
let $resultsn := cts:search(collection("a"),
cts:and-query((cts:or-query($searchTermsQ))))[1 to $resultsLimit]
Thanks in Advance
Regards,
judy
--- On Fri, 1/4/11, Clark Richey <[email protected]> wrote:
From: Clark Richey <[email protected]>
Subject: Re: [MarkLogic Dev General] Performance improvement
To: "General MarkLogic Developer Discussion" <[email protected]>,
"judie pearline" <[email protected]>
Date: Friday, 1 April, 2011, 6:43 PM
Judie,
It would probably be helpful if you posted the query code in question or at
least part of it so we could see how you are currently writing your queries.
----
Clark D. Richey, Jr.
Principal Technologist, Federal
MarkLogic Corporation
7950 Jones Branch Drive
McLean, VA 22102
Phone: 240 - CLARK - 07
(240 - 252 - 7507)
[email protected]
www.marklogic.com<http://www.marklogic.com/>
This e-mail and any accompanying attachments are confidential. The information
is intended solely for the use of the individual to whom it is addressed. Any
review, disclosure, copying, distribution, or use of this e-mail communication
by others is strictly prohibited. If you are not the intended recipient, please
notify us immediately by returning this message to the sender and delete all
copies. Thank you for your cooperation.
From: judie pearline
<[email protected]<http://in.mc958.mail.yahoo.com/mc/[email protected]>>
Reply-To: General MarkLogic Developer Discussion
<[email protected]<http://in.mc958.mail.yahoo.com/mc/[email protected]>>
Date: Fri, 1 Apr 2011 03:23:01 -0700
To: Mark Logic
<[email protected]<http://in.mc958.mail.yahoo.com/mc/[email protected]>>
Subject: [MarkLogic Dev General] Performance improvement
Hi all,
I have a scenario that needs to be resolved. Currently we have a 10 search
queries which searches in 10 different collection. The result will be displayed
by picking top ten results from each search results.
Is there any option to run all the searches in parallel. Or any other ways to
improve the performance of the search. Since the current sequential search
takes almost 6 minutes and we are using the cts:search.
Regards,
Judy
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
