Hi Bram,

Here is my experience : for what I saw in all our dictionnaries, the process order is always the same. I thought it was due to the ordered index structure.

If you look at http://temp.biblehistoriale.fr/rubrique/G/1 , you will see that order and results are always the same.

Code for extracting dictionary index is:

 let $indice := (POST variable)
 for $i at $position in db:open($isi:bdd)/root/fiche
    [some $o in entry/form/orth satisfies matches($o,concat('^',$l),'i')]
      where $position gt xs:integer($indice)  and $count lt xs:integer($indice) + 9 
       order by  xs:dateTime($i/creationDate) descending
        return
         $i

So I think that means that position() is stable.

2017-06-24 14:09 GMT+02:00 Bram Vanroy <bram.vanroy1@student.kuleuven.be>:

Dear list

 

We were wondering if BaseX always returns the results in the same order, even when using an XQUERY position(). In other words, if we only request the first 10 results as defined by position(), will this *always* be the same results, or is it possible that each time it will be ten different results? Or will caching and indexing alter the way in which results are returned first?

 

 

Thank you in advance

 

Bram Vanroy

https://bramvanroy.be

 




--
Ce message peut contenir des informations réservées exclusivement à son destinataire. Toute diffusion  sans autorisation est interdite. Si vous n'en êtes pas le destinataire, merci de prendre contact avec l'expéditeur et de détruire ce message.

This email may contain material for the sole use of the intended recipient. Any forwarding without express permission is prohibited. If you are not the intended recipient, please contact the sender and delete all copies.