Presently we are using CFSCHEDULE for distributing newsletters within the company intranet,
but due to the nature of our work customers are becoming increasingly interested in automation. for e.g., report enhancements and exception reports for fleet management, customers vary in size with regards to the size of their fleet, some 10 vehicles, others 200. An exception report involves looping through a full days worth of data, some 300 records, and calculating, the drivers start and end times, the time period the driver worked for the day (when the vehicle has not reported stopped), how long the vehicle was stopped and at what location, also driver behaviour - average speed, most break down in percent of locations visited etc..... there is quite a bit of data manipulation going there, and thats only for one vehicle, if it was 200, then I'm wondering just what would be they way to run these type of intensive schedules.... all customers like to have it done at the end of the day which will increase overhead, and they want the option of amending the schedules by adding vehicles and removing them. I am aware that SQL server has a Scheduler and that it would be best for performance, I suppose a CF template could be interfaced with SQL server to create the stored procedures and triggers, but I am wondering if anyone has undertaken this type of thing before, if they used any different types of tools, that interface with http that we should be looking at. Any help or advice would be greatly appreciated. J -----Original Message----- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 5:45 PM To: CF-Talk Subject: RE: What is the Limit of CFSCHEDULE My advice is Don't use it - especially if you are using 4.5 or lower (not sure about CF% tho.) - far better to use the NT scheduler (if it's on NT) or (SQL scheduler) as both rely on the OS system clocks. CFSCHEDULE is flaky at the best of times... J -----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 17:38 To: CF-Talk Subject: What is the Limit of CFSCHEDULE Greetings, I am trying to find Stats on the Limitations of CFSCHEDULE on cfserver, is there a recommended number of simultaneous schedules, Thanks for any help, John ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
