search

kercos / geomodel

Automatically exported from code.google.com/p/geomodel
0 stars 0 forks source link

Proximity Query very slow #20

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
I am not sure if this is a defect or not but the proximity query is very very 
slow. I have around 2700 records in the database with GeoCells calculated. 

When I run the search query, with 5000 proximity distance and 20 max results, 
it takes around 15-20 seconds to return the results. 
On DEV server, one auto generated index was added and I have added some more 
indexes but to no avail. 

I have not tried the code in Async branch, I will try with that but any help 
would be highly appreciated.

Thanks in advance.

Original issue reported on code.google.com by nitin.na@gmail.com on 25 Jun 2010 at 12:46

GoogleCodeExporter commented 8 years ago 
I got more than 100k records with GeoCells, and the query takes a couple of 
minutes on my machine.

Original comment by kaj.bjur...@gmail.com on 19 Sep 2010 at 3:04

GoogleCodeExporter commented 8 years ago 
I have 10000 elements in my database... My queries are very slow (>20 secondes) 
and the result is always an empty list...

Original comment by virginie...@gmail.com on 1 Aug 2011 at 3:36

GoogleCodeExporter commented 8 years ago 
Has anyone profied the proximity_fetch() call in their application with 
something like appengine-profiler?  Do you know where the time is being spent?

Original comment by kkawagu...@gmail.com on 4 Aug 2011 at 7:33