I am not sure what all information is needed to you. However, I am providing relevant Information here. Hope that is sufficient for you:
I have two vertices Stores and Products both extends V. Stores Looks like as follows: <https://lh3.googleusercontent.com/-2KhO5Z7d8CQ/VebBOsQmKsI/AAAAAAAABEc/60cGVcHVIIA/s1600/Screenshot%2Bfrom%2B2015-09-02%2B14%253A58%253A04.png> Products Look like: <https://lh3.googleusercontent.com/-_mPdI86cSHc/VebBhfF2ZlI/AAAAAAAABEk/LO3BsAw3Rlc/s1600/Screenshot%2Bfrom%2B2015-09-02%2B14%253A59%253A30.png> Now there is another class *hasInventory* that *Extends E*: ,* from Store to Products. (i.e. A store hasInventory of a product)*. This Edge *have a property "QTY"* Idea is to *Find product in all near by stores having qty > 0.* in Stores lat, lon have a spatial index. I was able to make it work somehow. But the query is taking too long, 16 sec 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" : 2000}] -- --- 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.
