Page 1 of 1
Searching with any order - Full Text Search Index
Posted: Wed Oct 22, 2008 4:59 pm
by howardthai
this will help get more converison if customers can find what they are looking for. The search would go into the title , descritions and find the keywords and populate the search page with it. Its really needed.
howard
Re: Searching with any order - Full Text Search Index
Posted: Wed Oct 22, 2008 11:01 pm
by Shopping Cart Admin
Hello Howard,
Please give us a more detailed explanation of what you want. The better you explain your request, the more likely it can be voted on and added. Thank you!
Re: Searching with any order - Full Text Search Index
Posted: Mon Oct 27, 2008 10:54 am
by nickc
Code: Select all
exec sp_fulltext_table @tabname=[ac_ProductSearchData], @action='activate'
- aggregate searchable text into a single table and bind it to SQL FTS
- cache the top "n" searches and expire them in time period "t" (global temp tables with GUID names works well for this)
- allow for admin demand-based FTS table rebuild and cache flush
Re: Searching with any order - Full Text Search Index
Posted: Tue Oct 28, 2008 12:43 am
by howardthai
Is there a way you can explain it step by step on how to get that sp to work on the searching.
howard
Re: Searching with any order - Full Text Search Index
Posted: Tue Oct 28, 2008 12:44 am
by howardthai
Just so that when customer search without buting the * to find the product info.