• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 599
  • Last Modified:

Please confirm: NotesDatabase.Search doesn't use the full-text index, even when there is one

On a different forum, I'm in a yes-no standstill with one of the experts. I say that Search doesn't use the full-text index of a database, whereas practically all the others state that Search does make use of the full-text index when there is one. I still find it very hard to believe, and I'd like some backup.

Does someone have a link to a document with some authority to confirm this??

Thanks!!
0
Sjef Bosman
Asked:
Sjef Bosman
  • 4
  • 3
1 Solution
 
CRAKCommented:
I required a NotesDatabase.Search a few weeks ago.
I can't remember the exact error message, but it was FT related!
After creating a full-text index, the error message had gone and it did deliver a vast number of results.
FYI: I'm not mistaken with the FTSearch method.
(Sorry!)
0
 
qwaleteeCommented:
CRAK, are you sure it was not .FTSearch? .Search uses formula language, which should not invoke the index ever.
0
 
qwaleteeCommented:
Sjef, could you link to the other question where you are under attack?
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
Sjef BosmanGroupware ConsultantAuthor Commented:
0
 
qwaleteeCommented:
Well, it wasn't the FT after all, from what I can gather in the last comment. And those who were insisting that Search uses indexes if available are dunderheads. They are confusing the fact that FTSearch CAN work without FTI present (just slower, and with limited search terms). You cna tell them that I said so ;)
0
 
Sjef BosmanGroupware ConsultantAuthor Commented:
If anyone here wants to vent his opinion on the matter, please feel free to do so! I'd still love to have the page with definite "authority" (pardon me please, Q) to really put an end to this.

In the meantime, let"s see if we can liven up the discussion a little...  ;-))
0
 
Sjef BosmanGroupware ConsultantAuthor Commented:
Thanks man, as always!

Sjef
0
 
Sjef BosmanGroupware ConsultantAuthor Commented:
This has now become the page with definite "authority" :-))
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now