You have to check the number of rows that are changed since the last execution (when it was upto 3 hours). Also rowcount on the current table(s) to see, as the volume of table will also dictate the performance of loading the rows. If this is accessed from a network share then you have to investigate...