On 11/18/2011 09:32 AM, John Arbash Meinel wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
...
A question - how are the indexes collated? Ie. does "Élèphant"
sort before or after "Elephant"? With the current locale of the
executing user? That could turn out "interesting" if I have two
boxes one in English and one in Danish...
This seems like a tricky problem unless the collation must be
specified at index creation time.
Cheers, Mikkel
ATM, querying an index does *not* sort the returned documents. So
applications are free to sort them however they like.
That's what I mean. An index, unless it's a hash index (which sqlite
doesn't even supprt), have an intrinsic ordering in which results will
be returned.
And if client side sorting is enforced there's really no point in not
just loading the whole dataset on doing the querying client side as
well. You'll need the whole dataset anyway to get sorting correct since
requesting the first 10 docs for term T on index I and then sorting
those docs is unlikely to be correct because it might well be doc11 or
docN>10 that should go in the first position.
Cheers,
Mikkel
--
Mailing list: https://launchpad.net/~u1db-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~u1db-discuss
More help : https://help.launchpad.net/ListHelp
