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...