Hi Damon,
Thanks for your reply.
When I do prof:report(xdmp:request()), for the same request, it shows the
elapsed time similar to the elapsed time in xdmp:elapsed-time() /
xdmp:query-meters().
<prof:metadata>
<prof:overall-elapsed>PT0.08659S</prof:overall-elapsed>
<prof:created>2013-03-20T06:23:57.022895-04:00</prof:created>
<prof:server-version>5.0-3.1</prof:server-version>
</prof:metadata>
But Profile from cq(clicking the profile button) shows "PT1M55.063478S". Now
is there difference between the prof:report() function and the profile button
click from (query console / cq)?
And what could be other possible reason's for the high commit time?
Server Details :
* Platform : Linux
* Host count : 1
* Version : 5.0-3.1
Document Details :
The size of the documents which I am updating is each of about (300KB to 600
KB), all these documents are present within a collection.
Total number of documents in the DB : 2485027
Disk Space :
Please find the disk space status of my ML server below:
[cid:[email protected]]
Thanks & Regards,
Santhosh Rajasekaran
From: [email protected]
[mailto:[email protected]] On Behalf Of Damon Feldman
Sent: Wednesday, March 20, 2013 7:58 PM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Elapsed time in xdmp:query-meter() ,
Profile time is showing more difference (Why it is not same for same query)-
reg.,
Santhosh,
xdmp:query-meters() measures time in the query, but does not capture time
"after" the query while the DB is committing the changes that result from your
transaction. That is, commit time for updates is not included in query-meters().
So query-meters() and profile together are showing you that your commit time is
very, very high. Only 11 updates in 2 minutes indicates something is wrong. Do
you have huge documents or system problems of some kind?
Yours,
Damon
--
Damon Feldman
Sr. Principal Consultant, MarkLogic
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Wednesday, March 20, 2013 7:16 AM
To: [email protected]
Subject: [MarkLogic Dev General] Elapsed time in xdmp:query-meter() , Profile
time is showing more difference (Why it is not same for same query)- reg.,
Hi All,
Warm regards,
I am trying to execute an xquery function which interanlly updates (insert
child node) to 11 documents in the database.
When i used query meter in my code, the total elapsed time is (PT0.081001S /
PT0.111622S)as below in different execution.
<qm:elapsed-time>PT0.081001S</qm:elapsed-time>
<qm:elapsed-time>PT0.111622S</qm:elapsed-time>
When i try to profile my query using CQ, (clikcing the profile button)
The profiled time is "PT1M55.063478S"
Eg: Profiled 2046 expressions in PT1M55.063478S
Why the time difference is high, Does profiling do some extra operation to
calculate the timing?(does it include data merge / query parsing / indexing
time also? )
Now in this case which time should i consider as execution time for my xquery
funcation?
Elapsed time / profile time.
Thanks & Regards,
Santhosh
Thanks & Regards,
Santhosh Rajasekaran,
"Think twice before you start programming or you will program twice before you
start thinking."
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient(s), please reply to the sender and
destroy all copies of the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email,
and/or any action taken in reliance on the contents of this e-mail is strictly
prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient(s), please reply to the sender and
destroy all copies of the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email,
and/or any action taken in reliance on the contents of this e-mail is strictly
prohibited and may be unlawful.
<<inline: image001.png>>
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
