Thx Ivan
Robby
From: Ivan Shcheklein [mailto:shchekl...@gmail.com]
Sent: Tuesday, February 05, 2013 9:39 AM
To: Robby Pelssers
Cc: ???? ?????????; sedna-discussion@lists.sourceforge.net
Subject: Re: [Sedna-discussion] retrieving values from index
Hi Robby,
We've added index-keys("idx-name") function. It returns all distinct keys. You
can try it with the latest dev build:
http://modis.ispras.ru/FTPContent/sedna/development/
Ivan Shcheklein,
Sedna Team
On Tue, Jan 15, 2013 at 7:07 PM, Robby Pelssers
<robby.pelss...@nxp.com<mailto:robby.pelss...@nxp.com>> wrote:
Exactly… what I need is a function index-keys. It should resolve my
performance issue as well being it a workaround ;-)
Robby
From: Ivan Shcheklein [mailto:shchekl...@gmail.com<mailto:shchekl...@gmail.com>]
Sent: Tuesday, January 15, 2013 1:14 PM
To: Олег Борисенко
Cc: Robby Pelssers;
sedna-discussion@lists.sourceforge.net<mailto:sedna-discussion@lists.sourceforge.net>
Subject: Re: [Sedna-discussion] retrieving values from index
Hi Robby, Oleg,
First of all, doc("$indexes") is not internal. It's one of the documented and
officially supported meta-documents.
Then, it doesn't return keys set (that's what Robby asked, am I right?) AFAIR.
Finally, it should be really easy to implement index-keys("index-name")
function if we don't have one right now. Oleg, please check that we 100% don't
have such function already.
Ivan Shcheklein,
Sedna Team
On Mon, Jan 14, 2013 at 1:22 PM, Олег Борисенко
<a...@somestuff.ru<mailto:a...@somestuff.ru>> wrote:
Hello! It's very simple to do. Sedna has special internal command that shows
all the information about indexes without scanning them.
For example:
test> create index "testind" on doc("test")/mediawiki/namespaces/namespace by
@key as xs:string &
UPDATE is executed successfully
test> doc("$indexes") &
<indexes>
<index name="testind" backend="btree" as_type="xs:string"
on_path="child::element(mediawiki)/child::element(namespaces)/child::element(namespace)"
by_path="attribute::attribute(key)" object_name="test" object_type="document"/>
</indexes>
Best regards, Borisenko Oleg, Sedna team.
On Mon, Jan 7, 2013 at 6:17 PM, Robby Pelssers
<robby.pelss...@nxp.com<mailto:robby.pelss...@nxp.com>> wrote:
Hi all,
I was wondering if Sedna also has some functionality available to just read all
keys from an index. So far I could only find the index-scan() in the docs
which I already heavily use but this time I only want a set of keys.
My use case is that I have indexes per collection for all logical document
indentifiers. Ideally I'd want to use the index to retrieve the list of those
identifiers by only using the index. As Sedna has this info stored (in my
context), it would be great to get hold of it.
So is it possible in some way?
Robby
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET<http://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. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net<mailto:Sedna-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET<http://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. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net<mailto:Sedna-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
