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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
