Well its right there... 35000 result records. Honestly Ismail, who reads line 17414 when the report has 50 pages? That CF uses so much time to output it and retrieve it from the resultset is clearly understandable. Try narrowing it down. Railo is much faster in generating such output, but I guess it's not an option.
Gert ismail cassiem schrieb: > Hi, > > I get the following result: I did the #get_info.Code# but still no luck. > > get_info (Records=35269, Time=3425ms) > > = 3425 Milliseconds = 3.425 Seconds (Coldfusion) > = 4 sql analyser > > it when it writes that's the problem. > > Execution Time > > 48910 milliseconds > 0 ms C:\INETPUB\WWWROOT\CFR\APPLICATION.CFM > 80 ms C:\INETPUB\WWWROOT\CFR\ISMAILC\MODULES\C_DB01.CFM > 0 ms C:\INETPUB\WWWROOT\CFR\ISMAILC\MODULES\C_MAXSCR.CFM > 10 ms C:\INETPUB\WWWROOT\CFR\ISMAILC\MODULES\C_USER01.CFM > 48510 ms C:\INETPUB\WWWROOT\CFR\ISMAILC\REPORTS\MIS010F2.CFM ---> = 48.51 > Seconds > 0 ms C:\INETPUB\WWWROOT\CFR\ONREQUESTEND.CFM > 320 ms STARTUP, PARSING, & SHUTDOWN > > Please help! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
