J
JulesVerne
Guest
First call at morning takes 15 seconds,
the second call takes only 1,5 seconds. What causes this delay? What can I log to identify it?
Even when I restart the DB I can't reproduce the behaviour of the first call. (In complex queries I measure difference of 15 minutes to 2 seconds)
Continue reading...
Code:
FOR EACH ... NO-LOCK:
END.
the second call takes only 1,5 seconds. What causes this delay? What can I log to identify it?
Even when I restart the DB I can't reproduce the behaviour of the first call. (In complex queries I measure difference of 15 minutes to 2 seconds)
Continue reading...