Hi Robby,

No, if you don't process or serialize value returned from an index-scan
call you don't have any penalties.

You query is ok, I believe.

Ivan


On Wed, Feb 20, 2013 at 6:35 PM, Robby Pelssers <robby.pelss...@nxp.com>wrote:

> Hi guys,
>
> I was wondering about the following.
>
> I ran the following XQuery against a very large collection (+- 16k
> documents)
>
>
> ****************************************************************************
> let $btIds := ("BLF3G22-30","BLF3G22-30","BLF2043","BLF2043","BLF2045")
>
> (: Remark in my case the list above took 20k identifiers :)
>
> for $btId in $btIds
> where empty(index-scan('basictype_id', $btId, 'EQ'))
> return $btId
>
> ****************************************************************************
>
> But the index-scan function returns the document where I'm actually
> already satisfied with knowing if the value is present in the index. I did
> not see any function that returns a Boolean however (if $value in index).
>
> Does this have a severe performance penalty I was wondering?
>
> Robby
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_feb
> _______________________________________________
> Sedna-discussion mailing list
> Sedna-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to