search

databricks-industry-solutions / geospatial-neighborhood-searches

Implementing geospatial searches at Scale on a distributed platform
Other
3 stars 1 forks source link

Support clustering of the same searches #10

Open zavoraad opened 11 months ago

zavoraad commented 11 months ago

Searches that use the same search space should be grouped together in one call to reduce the number of queries needed to run.

zavoraad commented 9 months ago

%sql --Demonstrating opportunity for performance enhancement by reusing query results https://github.com/databricks-industry-solutions/geospatial-neighborhood-searches/issues/10

select searchSpace, count(1) as cnt from geospatial_searches.search_results_serverless group by searchSpace having count(1) > 1 order by cnt desc limit 100