CODEWITHSUNDEEP
timeoutsettingsmarklogictime-limiting
s.e
s.e

Reputation: 271

Marklogic: XDMP-EXTIME error (Time limit exceeded)

I'm facing a very serious problem when running a set of queries. I'm getting the following error: Time limit exceeded. I tried to run them each at a time and they returned. Although I've changed the default time limit, max time limit, session timeout ..., but the error message appears after approximately 1 minute. Note: I'm executing my query using Query Console. The error appears after 2147 seconds The attached photo is a screenshot of my server settings.time settings

How to solve this problem?

Upvotes: 3

Views: 2191

Answers (2)

Harry Bakken
Harry Bakken

Reputation: 793

It sounds like a better approach to solving the problem is to improve your queries, instead of increasing time-out limits. Unless there's absolutely no other way to write the queries, index the data, or structure your data to make it more efficiently searched, you should be able to tune your queries to get acceptable performance.

More information about this is in the Query Performance and Tuning Guide on the MarkLogic site- http://docs.marklogic.com/guide/performance

Upvotes: 2

wst
wst

Reputation: 11773

It can matter how exactly you're executing your queries (i.e.: HTTP, XDBC, QConsole). Try adding before your query, either:

xdmp:set-request-time-limit(3600)

or:

xdmp:set-transaction-time-limit(3600)

Upvotes: 3

Related Questions