You are replying to:

1. • 
   • Nick Partridge
   • Posted on Tue 1 Jun 2004

   This is purely subjective, but it seems to me that it is faster - but when done a large number of times.

   I tested three small agents, the first used an @dblookup like this:

   value := @DbLookup("" : "NoCache";"";ID;"field"); FIELD myfield := value;

   The second:

   value := @DbLookup("" : "";"";ID;"field"); FIELD myfield := value;

   And the third

   value := @GetDocField(ID;"field"); FIELD myfield := value;

   My results for around 10000 documents were:

   Dblookup (no cache): 20 seconds Dblookup (cached): 13 seconds

   GetDocField: 15 seconds

   Again, very subjective - I did run the tests a few times and made sure there was no other load on my machine, but the results were consistent.

   Food for thought.

Your Comments