It times out on 23 million documents for my current server configuration.

I've reduced my database size to a more reasonable size but I still
need a few more GB of real memory.  As such, I suspect that query
induces paging and slows everything down.

On Thu, Jul 5, 2012 at 12:09 PM, Ryan Dew <[email protected]> wrote:
> So why is the example from the documentation so bad? The expression is fully
> searchable and will only return directory properties, so having millions of
> documents shouldn't matter. The only count that should really matter are the
> number of directories. Then if you really wanted to you could paginate over
> the results using fn:subsequence.
>
> xdmp:plan(xdmp:document-properties()/prop:properties/prop:directory)
>
> and this might be slightly more efficient:
>
> xdmp:plan(xdmp:document-properties()/prop:properties[prop:directory])
>
>
> On Thu, Jul 5, 2012 at 12:49 PM, Will Thompson <[email protected]>
> wrote:
>>
>> Do you have directory creation set to automatic in your database settings?
>>
>> -Will
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of Alex Milowski
>> Sent: Thursday, July 05, 2012 11:48 AM
>> To: MarkLogic Developer Discussion
>> Subject: Re: [MarkLogic Dev General] Listing Directories?
>>
>> On Thu, Jul 5, 2012 at 11:37 AM, Danny Sokolsky
>> <[email protected]> wrote:
>> > You don't need the URI lexicon for the xdmp:estimate one.
>>
>> OK.  Good to know.
>>
>> What I really want to know is the name and purpose of these directories
>> since I don't actually create them explicitly.
>>
>> --
>> --Alex Milowski
>> "The excellence of grammar as a guide is proportional to the paucity of
>> the inflexions, i.e. to the degree of analysis effected by the language
>> considered."
>>
>> Bertrand Russell in a footnote of Principles of Mathematics
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>
>
>
> _______________________________________________
> General mailing list
> [email protected]
> http://developer.marklogic.com/mailman/listinfo/general
>



-- 
--Alex Milowski
"The excellence of grammar as a guide is proportional to the paucity of the
inflexions, i.e. to the degree of analysis effected by the language
considered."

Bertrand Russell in a footnote of Principles of Mathematics
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general

Reply via email to