Which one is more advisable- db.FTsearch or Notescollection.FTsearch.
Which one doesn’t create any performance issues for applications.
Subject: RE: which is more advisable-db.FTsearch or Notescollections.FTsearch
Either one should give reasonable performance provided you have a full-text index. Searching the collection might be better; it probably depends on the size of the collection.
How did you get the collection you would be searching in? Could we possibly do the search at an earlier point so that the collection already contains only the information you want?