Tuesday, April 2, 2019

Full Text Search for Business and Place Finder


Working on a website called Near Me and creating full text search index which allow searches by distance using latitude and longitude. Similar to Google Places but based on distance rather than rating.

It is interesting how SQL Server is able to handle spatial indexes with full text search but having millions of records in the table does not make it easy so i decided to give Lucene a try, but Lucene.Net is very slow unless you keep the data in memory.