1. what is the best solution to improve the following distance query in order to improve the performance.
SELECT count(*) FROM place WHERE DISTANCE(lat, lng, 42.0697, -87.7878) < 10 2. The query always warn the following message if you have large data set around 80k fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index" 3. create the following index but it's not involved in that query. place.distance NOTUNIQUE ["lat","lng"] SBTREE -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
