Personally, I would set up a page system that returns a set of records then the whole thing at once.
Maxrows and Startrow are your friends. :) Andrew Scott wrote: > You will first need to look at the amount of records are returned by the > query. > > > > On 8/24/07, Benjamin Rosenthal <[EMAIL PROTECTED]> wrote: >> I'm trying to run this query using Coldfusion 8 on IIS and MySQL 5. >> >> If I run the query directly off the database the results are returned >> quickly. >> >> If I run the query through CF 7, it's pretty slow but still runs. If I >> run the query through CF 8 it takes FOREVER, then times out. >> >> Any idea what I'm doing wrong, and what's happening in CF8? I'm no DB >> expert. What things should I look into optimizing here? >> >> >> <cfquery name="theOrders" datasource="#Application.ds#"> >> SELECT o.orderid, o.dealer, o.dealerRep, o.dealerPO, >> o.dealerShippingInstructions, o.dealerFreightCollect, o.othershipping, >> o.billoflading, o.carrier, o.othercarrier, o.serialno, o.ShippingDate, >> o.Shipping, o.ShippingTotal, o.SaleSubTotal, o.SaleTotal, o.Tax, >> o.Discount, o.DiscountRate, o.Status, o.DateIn, o.bFirstName, o.bLastName, >> o.bAddress1, o.bAddress2, o.bCity, o.bState, o.bZip, o.bPhone, >> o.sFirstName, o.sLastName, o.sAddress1, o.sAddress2, o.sCity, o.sState, >> o.sZip, o.sPhone, o.sPhone2, o.Message, o.dealerShippingInstructions, >> o.bCompany, o.sCompany, o.bEmail, o.ipaddress, o.oAuthorization, o.CCType, >> o.CCNum, o.CCName, o.CCYear, o.CCMonth, o.entryDate, i.RelProductID, >> i.Quantity, i.RelUnitPrice, i.Shipping, i.Discount, i.title >> FROM tblorders as o, tblorderitems as i >> WHERE o.OrderID=i.Relorderid >> ORDER BY OrderID ASC >> </cfquery> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
