>>Hi everybody,
>>
>>I noticed, that our table rule UpdateUserAndTime() takes too much time. It calls another procedure called GetUserID(). I'm thinking, it would be nice to use some global var instead. But the problem is where we set this variable and release it. One of the ideas is to use DBC events.
>>
>>What would be your suggestions here?
>>
>>Thanks in advance.
>
>GetUserID takes only nanoseconds. However I too get it once in login form and store in oApp.oCurrentUser.
>Cetin
Thanks. We're thinking about having a switch to turn off the rule firing completely. Also in our tests for 100000 records it seems to be almost 3 times faster with using constant instead of GetUserID() in the replace command.
If it's not broken, fix it until it is.
My Blog