I have a scheduled task that runs once a day that builds an XML file that I pass off to another group. Recently the amount of data has greatly increased and is now causing the task to time out (I think). I have tried to optimize my script as much as possible but with no luck. It times out long before an hour and I don't get any kind of ColdFusion error. Instead I get a "This page cannot be found" after it runs.
Could this be a timeout someplace other than Coldfusion?
Is there a more efficient way to build this XML file?
select PersonID, FirstName, LastName
from People
select d.DepartmentID, DepartmentName, pd.PersonID
from Department d inner join PersonDepartment pd on d.DepartmentID = pd.DepartmentID
select PaperID, PaperTitle, PaperDescription, pp.PersonID
from Paper p inner join PersonPaper pp on p.PaperID = pp.PaperID
select DepartmentID, DepartmentName
from getDepartments
where PersonID = #getPeople.PersonID#
select PaperID, PaperDescription
from getpapers
where PersonID = #getPeople.PersonID#
#getPeople.PersonID#
#getPeople.Firstname#
#getPeople.LastName#
#getPersonDepartments.DepartmentID#
#getPersonDepartments.DepartmentName#
#getPersonPapers.PaperID#
#getPersonPapers.PaperDescription#
Done!
