Hi Ajay can you post the explain of this query?
2015-09-02 10:54 GMT+02:00 Ajay Shenoy <[email protected]>: > I have created a database with two vertices in it. *Stores*, *Products*. > Stores have a *GeoSpatial Index*. There is an Edge '*hasInventory*' from > store to products which holds quantity for each Product-Store relation. Now > If I have to find a particular Product(sku) in near by stores how should I > proceed. > I tried like: > > Select @rid,name,address,lat,lon,$distance from *Stores* where @rid IN > (Select out.@rid from *hasInventory* where *in.sku* = '8907103076739' and > quantity > 0) and [lat,lon,$spatial] NEAR > [19.195524,72.834810,{'maxDistance' : 20}] > > Its gives me result but takes around 14 seconds to give response. > > *Please suggest a solution for faster response time.* > > Thanks in advance. > > -- > > --- > 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. > -- --- 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.
