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