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


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to