Warning: Agent is performing full text operations

HCL Domino Domino Forum
1

I have a two agents that suffer the same problem and it’s starting to drive me mad!

The agents run server-side, are both written in formula and they both consist of a SELECT and a field assignment (FIELD := x).

One of the agents has the following code:

SELECT Form = “frmConfig” & Enabled = “Enabled” & Status *= “Pending”:“Complete” &

((RunNextDateTime = “”) | (RunNextDateTime < @Now));

FIELD Status := “Queued”;

When the agent is set to run against all documents in the database it runs without warning. Not very efficient IMHO as it’s scanning every document in the database (over 10,000 of them) to determine which ones to process.

When the agent is set to run with a search criteria, and that search criteria is “In folder ‘(Configs)’”, the agent gives the warning (in the server log):

“Warning: Agent is performing full text operations on database ‘testdb.nsf’ which is not full text indexed. This is extremely inefficient.”

The view’s formula is nothing special - just a “SELECT Form = ‘frmConfig’” - i.e., it just narrows the search from over 10,000 docs to around 8. Correct me if I’m wrong but I don’t understand why using a view to narrow the scope of an agent is “extremely inefficient”. It doesn’t add up.

Does anyone have any idea what the point of this warning is, whether I’ve missed something obvious, and how to stop it? I don’t want to FT index the database because apart from this warning there’s no reason to.

Many thanks in advance for any ideas!

  • Phil
2

Subject: Warning: Agent is performing full text operations

This probably is not the answer that you want but I believe that as soon as the agent sees that there is a search criteria it assume that it will us a FTS (not always the case as in your case). What I would do is write the code as an LS agent open the folder and update the documents. A little more coding, but gets the job done. The Formula Language is great but it is limited.

3

Subject: RE: Warning: Agent is performing full text operations

Thanks for the suggestion on using LS. Can’t think why i didn’t just do that anyway (sometimes it takes an “outsider” to point these things out to me!). Anyway you’ve saved me another couple of hours banging my head against a wall, so thanks!

  • Phil