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:287171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
