Full Text Search Results

[meer2005]

When full text search is enabled, there seems to be an issue with what is displayed and the paging and narrow results. As an example, if we search for an item on our site 3 items show up in the results and they are the most relevant, but it says Displaying items 1 - 30 of 352 items, but only shows 3 items -- the paging extends past six pages, all of which are blank. Where are the other 349 items it says it's displaying? How can this be changed so the actual results match what it says it's displaying?

[Katie]

Which version of AbleCommerce are you using? Can you put the website name here and the search criteria? I'd like to test this out.

[meer2005]

I sent you a PM. Thanks!

[Katie]

I'm not sure of the exact build you are using, but if you are on 7.0.3, then I would take a look at this service update -

http://help.ablecommerce.com/index.htm# ... _7.0.3.htm

There are a number of bug fixes for FTS. I hope that will take care of the problem.

[meer2005]

Seems like that fixed it. Is there anyway to see the status of the index? I did a rebuild of the index about 5 hours ago and still have some items that don't show up in search.

[Katie]

Sorry, not that I know of, but it shouldn't take that long unless you have a tremendously huge database. SQL has some tools that you might want to use to improve performance.

FIRST PHASE: Build SQL Profile

The sql profile basically is a log of all queries run on a server in a specific period. You need to build a log file from the server that contains a good sampling of data. So for example you might log all queries over the course of 10 minutes, or log 5 mb worth of queries.

1) Run SQL Profiler (Enterprise Manager -> Tools -> SQL Profiler
2) Go to File -> New -> Trace
3) Connect to Server, (if running from server itself, just click OK)
4) Specify the trace name. Also click Save to file and specify a file location. If you want, you can specify either a maximum file size or a time to stop running the trace.
5) Click Run. The screen will start to display all of the queries captured. You can stop the trace when you have enough data by clicking the red stop button. Or if you have specified a trace stop time, you can let it run until that time and it stops on it's own.

Once the trace is done, you have a file of the sql queries.

SECOND PHASE: Run Tuning Wizard

1) Run Index Tuning Wizard (Sql Profiler -> Tools -> Index Tuning Wizard
2) Intro screen, click next
3) connect to server
4) specify the database. also select the tuning mode. Click next.
5) Select My workload file. Then locate the file you created from sql profiler. Click next.
6) Select all tables, click next.
7) The index tuning wizard will analyze all of the data. When it is through, you will be given a list of index recommendations. Click next.
If you like the recommendations, click Apply changes. You can then choose to implement them now (probably best) or to do it at a certain time. Make your choice and click next.
9) Click finish.

It's pretty easy to do. This would be a good step to perform on any live site. It can only improve performance.

[meer2005]

Still not getting results on some of the items, even when searching exact title. Is there just a way to say if simple search finds no results, display results from advanced search? Maybe by combining the two, we'll fill in the holes.