I can limit records returned through query to say 15 or 20 or 25 rows
but my problem is that the calculation that i needs to do on returned
records needs results with distance in ascending order. It may be that
in first 25 rows, there may be distances that are greater than the
distances
Which is percisely what is not supported.
Imagine for a minute that the datastore supported it, it would work
quite well with say 100 records. Even 1000 records might work at a
push, but once you start getting to about 10,000 the datastore would
almost certainly start to cry, and soon fall
App Engine (well the Datastore) can't run queries like that.
Remember App Engine is designed with scaling in mind, the application
should function the same if 1 person is using the app or a million
(performance wise), tradional database systems and sql in particular,
make it very easy to define