Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Freetext Search of DB table

  • 11-03-2008 11:12PM
    #1
    markf909
    Closed Accounts Posts: 461 ✭✭


    Basically, I need to implement a free text search of a DB table with 100,000's of entries. I'm normally an app programmer so this is quite new to me and myself and a colleague spent a bit of time coming up with hare brained solutions for this today. I know this is a solved problem so if anyone can point me towards the correct resources then that would help.

    The search query will be entered via a web form.

    So what is the process when someone searches for a product, say on amazon and searches in all products? It searches the products column and can create a table with the result sets.

    Is this the correct way of going about this?
    SQL Server Freetext

    What are the strategies then for pruning that table into something more representative when this result set is huge?

    How does one refine the set to be more selective, say one of each entry?

    Sorry for the general questions, if folks here have some good links to examples it would be much appreciated, this whole web to DB thingy is all very new to me.


Comments

  • #2
    Cantab.
    Closed Accounts Posts: 1,444 ✭✭✭Cantab.


    markf909 wrote: »
    Basically, I need to implement a free text search of a DB table with 100,000's of entries. I'm normally an app programmer so this is quite new to me and myself and a colleague spent a bit of time coming up with hare brained solutions for this today. I know this is a solved problem so if anyone can point me towards the correct resources then that would help.

    The search query will be entered via a web form.

    So what is the process when someone searches for a product, say on amazon and searches in all products? It searches the products column and can create a table with the result sets.

    Is this the correct way of going about this?
    SQL Server Freetext

    What are the strategies then for pruning that table into something more representative when this result set is huge?

    How does one refine the set to be more selective, say one of each entry?

    Sorry for the general questions, if folks here have some good links to examples it would be much appreciated, this whole web to DB thingy is all very new to me.

    Make the query as specific as possible and let SQL do the rest (pruning efficiencies etc.)

    A couple of 100,000 entries isn't that big.


Advertisement