Forum ‹ BigDB ‹ Combining, LoadKey and LoadRange

[Thijs]

Hey, is it possible to Load a set of Keys that are filtered and limited to the amount of results? I want to do this because i have a list of friend ids and i want to retrieve the 10 highest scores, but i dont want to load every friend to sort it out on the client side.

[Henrik]

No, that is not possible, LoadRange only works over indexes. And I suspect that in your case, it's not possible to make an index that covers it.

[Thijs]

Any ideas on how/if i could create something similar without destroying my data limit?

[Henrik]

You could keep an extra table that only contains objects with a single property that is the score, and the same keys as your main table. That way you can do a full LoadKeys from the small table, sort them in your game, and the load the actual top-10 objects.