[Sedna-discussion] poor performance for large collection

[Robby P. <rob...@nx...>]

Hi all,

I have a single collection of 24468 documents. 

<count>{count(collection("chemicalContent/released")/TypeName)}</count>  == 24468

When I just try to run below statement it takes very long to execute. The documents themselves are not even that big varying between 2kb and 12kb.

for $i in collection("chemicalContent/released") return document-uri($i)

I also have a index on that collection:

create index "chemicalcontent_id"
  on fn:collection("chemicalContent/released")/TypeName
  by @id
  as xs:string

Is it normal for that statement to execute that long   (> 1 minute) ?


Is there a way to perhaps speed up fetching a list of all @id's for that particular collection?

Thx in advance,
Robby