How do I find whether my server is under heavy load or not? Actually the query used is returning around 80000 records. So it has loop over this recordset to display only 100 records on the page. Is this the reason why it is taking time??
That doesn't look bad to me, is your server under heavy load, or is your >disk source for this template having issues? > > > >-----Original Message----- >From: hussain shaikh [mailto:[EMAIL PROTECTED] >Sent: Tuesday, January 23, 2007 6:54 AM >To: CF-Talk >Subject: Re: Help Needed for fine-tuning CF code > >>Can you post some code examples? >> >>Chris >> >Following is some of code of one of my web page:- > ><cfoutput query="inventory2csvlist" startrow="#start#" >maxrows="#start+step-1#"> ><tr bgcolor="#CfgRet.Color2#"> ><td align="left"> >#inventory2csvlist.ROUTER# ></td> ><td> >#inventory2csvlist.IP# ></td> ><td> >#inventory2csvlist.VPN# ></td> > <td> >#inventory2csvlist.CEIP# ></td> ><td> >#inventory2csvlist.INTERFACE# ></td> ><td> >#inventory2csvlist.DESCRIPTION# ></td> ><td> >#inventory2csvlist.FUNCTION# ></td> ><td> >#inventory2csvlist.ENCAPSULATION# ></td> ><td> ><a >href="listInventory2csv_details_spring.cfm?router1=#inventory2csvlist.RO >UTER#&interface1=#inventory2csvlist.INTERFACE#&start=#start#&sort=#URL.s >ort#&router_r=#router_r#&vpn_v=#vpn_v#&interface_i=#interface_i#">View >Details</a> ></td> ></tr> > > ></cfoutput> >Note:-start=1 and step=100 > > >Also Debugging is disabled. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
