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
Searching with any order - Full Text Search Index
-
- Ensign (ENS)
- Posts: 20
- Joined: Wed Oct 22, 2008 4:46 pm
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: Searching with any order - Full Text Search Index
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!
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
Code: Select all
exec sp_fulltext_table @tabname=[ac_ProductSearchData], @action='activate'
- 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
Nick Cole
http://www.ethofy.com
http://www.ethofy.com
-
- Ensign (ENS)
- Posts: 20
- Joined: Wed Oct 22, 2008 4:46 pm
Re: Searching with any order - Full Text Search Index
Is there a way you can explain it step by step on how to get that sp to work on the searching.
howard
howard
-
- Ensign (ENS)
- Posts: 20
- Joined: Wed Oct 22, 2008 4:46 pm
Re: Searching with any order - Full Text Search Index
Just so that when customer search without buting the * to find the product info.