Looks like my reply got hosed somehow. In any case, to make a long story short, two of the DBs I hit come with some ugly latency, so 2 seconds is the best I can do. I always try to hit 250ms or less in anything I do in CF, but sometimes exceptions have to be made.
CF Admin can't be the issue -- I have a 60-second limit on templates, but that's meaningless when you have cfsetting requesttimeout=xxx on the page. If there's no solution to this, then I'll need to run the script in steps -- 300 or 400 records at a time. > On Wednesday 13 Jun 2007, Sung Woo wrote: > > happening that I don't think I can replicate in a SP. At least not > easily. > > And besides, it's already written in CF, so I can't go back now. > > You can (should ?) if it is running for too long. > > > 2 seconds for a transaction that ties together data from four > discrete > > databases is OK in my book. > > I'd expect it to run in well under a second. Tens of milli's, ideally. > > Maybe that's just me. > > > My main question still remains unanswered -- > > is there some place in CF where a 600-second template limitation > exists? > > The CF admin., not unusually. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4