Show the output of top cmd. Quote the basic HW specs
top cmd when problem appears.
Also, how many users on at that pt in time?
What application prog language; do you really mean date field on web page and datetime from the DB?
Check the app code; is it using an indexed column on DB?