Well it surely is something that you should not do. Since 80000 records are somethin that has to be skipped through even when you only skip through 100 records. Try only to query 100 the records you need...
You can easily check this by using GetTickCount() before and after the QueryOutput... Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ hussain shaikh schrieb: > 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:267266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
