Suggestions on implementing a search engine
-
Hi all, I have taken ownership of a Sql 2008 database that has a huge number of rows with HTML content. I need to implement some new functionality that would let users intelligently search through within the HTML of these records. Any suggestions? thanks, Saurabh
saurabh
-
Hi all, I have taken ownership of a Sql 2008 database that has a huge number of rows with HTML content. I need to implement some new functionality that would let users intelligently search through within the HTML of these records. Any suggestions? thanks, Saurabh
saurabh
Member 179330 wrote:
Any suggestions?
Free Text Search, it's part of Sql Server. If you got a lot of spare time, you could build something similar yourself; fetch all the varchar-fields that contain the text, count how often it occurs, add a bonus if the text occurs in a title, and you have an 'intelligent' search :)
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hi all, I have taken ownership of a Sql 2008 database that has a huge number of rows with HTML content. I need to implement some new functionality that would let users intelligently search through within the HTML of these records. Any suggestions? thanks, Saurabh
saurabh
Member 179330 wrote:
huge number of rows
Where "huge" means what exactly?
Member 179330 wrote:
with HTML content.
Where "html" means what exactly? More specifically the html represents what type of data? If there are tables, versus pictures, versus blog posts it impacts what one might need to focus on searching for.