I have 4 site workflows, each of the workflow will loop through a list of about 100 items. I made 4 schedules for those 4 workflows to run overnight. When I check the lists I do see the updates in each list, that means the workflow ran overnight. The problem is, when I try to open "View Workflow History", I got error. I looked the log and it said database connection time out. I understand that the workflows generated lots of records in history and it could be the problem. Can any body point me a direction that I can solve this problem.
Thanks in advance!