Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

This has happened a few times in the last days:

I'm trying to use the forum search bar and use a few keywords, such as "Android HTTP", and for sure, there is one current question containing both words - but the search does not find any match.

What am I doing wrong?

asked 11 Jun '15, 05:02

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

Haha - now that exact search lists this question:)

(11 Jun '15, 05:03) Volker Barth
Replies hidden

Maybe HTTP is on a stop list ;-)

(12 Jun '15, 07:30) Martin

It's also gone quite slow again - several minutes yesterday for a free text search, 30/40 seconds today. A few weeks ago it was pretty well instantaneous.

(12 Jun '15, 07:41) Justin Willey

My sincere apologies. When I upgraded the OSQA software back in late March, I inadvertently disabled the SQL Anywhere full-text search capabilities, which left us with the standard "where question_text like '%searchstring%'" search algorithm. I have re-enabled the full-text searching and now we get much better results.

permanent link

answered 15 Jun '15, 15:15

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124
accept rate: 54%

and now we get much better results.

Yes, yes, yes (and faster results, too) - thanks:)


BTW: Does the full-text search look for tags, too?

Own answer: Apparently it does, see that separate FAQ:)

(16 Jun '15, 04:08) Volker Barth
Replies hidden
1

Yes. The search looks through all questions, answers, comments, titles, and tag names.

(16 Jun '15, 08:48) Graeme Perrow

Testing indicates the forum search is doing an exact match, possibly using LIKE '%search-string%'.

Search: for Android support

One result which contains the exact string "for Android support": Does Ultralite 16 for Android support TCP connections?

Search: for support

Five results containing the exact string "for support", but NOT the message which contains "for Android support".

permanent link

answered 11 Jun '15, 08:16

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 11 Jun '15, 08:30

Well, I guess it has worked differently in the past, at least a few months ago me and others had the impression the search would work really well (and fast)...

Note: It seems to not really doing an exact match, at least a search for "for Android support" - as copied from your answer - does not list this FAQ as result.

(Or is it possibly using a text index and does not update that immediately?)

(11 Jun '15, 08:36) Volker Barth
Replies hidden

Looks like the search got switched to use phrase search - we will investigate.

(12 Jun '15, 10:40) Elmi Eflov
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×178
×15

question asked: 11 Jun '15, 05:02

question was seen: 1,913 times

last updated: 21 Jun '15, 06:27