Fast Search for SharePoint gotcha - query suggestions

At the company i work for, we do have around 30(?!) different labels and we decided that all websites of those labels, should be hosted on one platform: SharePoint 2010. This consolidation to one platform should really decrease costs, because we now have one generic way of developing, one platform to take care of and we can reuse a lot of components.  One of the service applications that we wanted to reuse amongst all applications, is the Fast Query Service Application, as we have a Fast instance running.  Our labels are really enthousiast about the Fast Search for SharePoint capabilities due to fact that a lot of interesting features, like visual best bets, can be configured from within the UI. Other things, like new ranking models can easily be configured via powershell. There is just one index, with all public information in it: personal details or things like that, will not be indexed! By configuring scopes in a correct way, we can prevent information from label 1 to appear in the search results on label 2. If, for some reason, those results appeared by accident (wrongly configured scope), that wouldn't be too much of a problem, as that can be fixed real soon.

The gotcha ;)

Query suggestions is one of the features that can be manually configured by registering new resourcephrases from within powershell, but it is self-learing too, based on query terms and click-throughs. Sadly enough, this is service application specific. But what does this mean?

Now the following case: We have two labels "Centraal Beheer" and "Interpolis", who are offering the same, competitive products. Imagine that Interpolis demanded us to add a query suggestion for the word "Interpolis". That could easily be added by executing the following powershell:

$queryapp

 

 

 

= Get-SPEnterpriseSearchServiceApplication 'FastQuery'
New-SPEnterpriseSearchLanguageResourcePhrase -Language en-us -Type QuerySuggestionAlwaysSuggest -SearchApplication $queryapp -Name "Interpolis Verzekeringen"

As this query suggestion is added to the service application itself, and not scoped to a custom scope, webapplication or site collection, every web application that consumes this Search Query Application, will suggest the word interpolis. For competitive labels, this will be a major issue! Features as user contexts (till a certain spot) and keywords can be scoped on site-collection scope, suggestions not :(
Imagine that the suggestion "Interpolis Verzekeringen" pops up when searching for "Intake Insurance" on the competitive site of "Centraal Beheer"? I wouldn't be too happy if I was a business owner of "Centraal Beheer".

Luckily, this can be solved by adding a second search service application, but if that's the way to go: I don't know. A second search service application can be used, but requires 3  extra databases to be created:

  • Crawlstore_DB
  • Query_DB
  • PropertyStore_DB

For smaller organisations, this shouldn't be too much of a hassle, but in a large company, this can cost a lot of extra money, due to (but not limited to) SLA's, extra administring of databases, storage and backup. And maybe are two service applications easy to manage, but what about 30 service applications (one for each label?).I think that the same architecture that is used for keywords and usercontexts, should be used for the query suggestions. Suggestions would even be manageble on site collections, what would be an extra advantage for FAST.

PS: this problem arises for SharePoint enterprise search as well ;)
PS2: Who not using a multi tenant environment? Fast doesn't support that and we don't need it ;)

Published Tue, Jul 19 2011 12:07 PM by Bas

Comments

# re: Fast Search for SharePoint gotcha - query suggestions

Wednesday, July 20, 2011 1:21 PM by Mikael Svenson

There is only one solution, use lists and create the auto-suggest feature yourself. Well, the best option is to combine them.

In a custom search box web part, get the autosuggest list from the search engine, then execute a search for each term to check that you are actually getting results (adding the scopes to the query). Also vet any auto-suggest from the search engine with a custom list for your particular tenant/customer/label.

Not sure if it's easier than creating multiple Search SSA's, but certainly a better architeture imo.

# re: Fast Search for SharePoint gotcha - query suggestions

Friday, July 22, 2011 9:10 PM by Bas

totally agree on the architecture thingy, mikael. The solution that you describe, is, indeed, a solution. A much simpler solution would be to create a sharepoint list with possible suggestions in it and query that list with some jquery and the client object model.

I still think this is a point that microsoft should fix in their architecture ;)

# Multiple Query Search Service Applications?

Wednesday, November 09, 2011 5:10 PM by Sezai Komur

I have tried creating multiple Query SSA's before connecting to the same FAST Server Farm, it seems to work, someone then notified me about this on TechNet below, it seems unsupported?

technet.microsoft.com/.../ff602184.aspx

Note: You must only deploy one Query SSA associated with your Microsoft FAST Search Server 2010 for SharePoint farm. You can scale out the FAST Search Query SSA across multiple servers for performance and failover.

# re: Fast Search for SharePoint gotcha - query suggestions

Thursday, November 10, 2011 9:53 PM by Bas

Sezai, thanks for your comment. I doubt if this is unsupported, but will contact microsoft about it for an official word on it.

# re: Fast Search for SharePoint gotcha - query suggestions

Tuesday, December 13, 2011 6:53 PM by Saturnino

Hello, all I just got word from Microsoft that although the documentation does clearly state that multiple FAST Query SSA's will not be supported.  So multiple FAST Query SSAs will be supported until the next very of FAST & SharePoint where this issue will be addressed.

# re: Fast Search for SharePoint gotcha - query suggestions

Tuesday, December 20, 2011 7:51 PM by Mikael Svenson

The reason why having multiple SSA's is a bad idea could be due to property, keyword and scope handling. The FAST Search Admin link is tied to the GUID of the SSA.. and there might be sync issues if you have multiple Query SSA's against the same FAST index.

I have not tried this so only speculation on my part.

Leave a Comment

(required) 
(required) 
(optional)
(required) 
Please add 4 and 1 and type the answer here: