Scheduled task timing out

[drizzage]

I have a scheduled template that needs slightly longer than 60 seconds to run. It’s timing out, and not allowing all of the processes to run. The problem is, I’m on a shared server where all scheduled tasks must be set through the administrator, and the host is not willing to extend the time limit of scheduled templates. I understand their reasons, but the entire template needs to run to be effective. I tried using a <cflocation> to a different page with a requestTimeout, but that of course did not work since cflocation requires an end browser. The only thing I can do is to break the template up into smaller sections, and put them all on separate schedules. But the queries are all interdependent, and that would require reengineering the entire process. I’d rather not tackle that if I don’t have to. Plus, I’m not sure if my host will allow me any more scheduled tasks.

Does anyone have any tips/tricks?

 

[TruthInSatire]

What are you trying to do? It's usualy faster to let the database do a lot of work. For example. Use coldfusion to import an excel sheet. first you have to query the excel sheet (cfhttp), then take the results and insert each row back into the database. This took around 2 or three minutes depending on the csv file. We quickly decided that wasn't going to fly so we put that burden back on the database. It takes 3 or 4 seconds now.

If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett

 

[drizzage]

Much of it is sending mailing lists, and other dynamic queries that change daily and cannot be done automatically.

 

[TruthInSatire]

well, IF there is no other way to do it, look for a host that will meet your needs.

If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett