优化订货宝日志优化相关.docxVIP

优化 SQL ： SELECT c.Coding, c.Units, c.ID, c.OrderID, c.ClientID, c.ContentID, c.ContentName, c.ContentColor, c.ContentSpecification, c.ContentPrice, c.ContentNumber, c.ContentPercent, c.ContentSend, o.OrderSN, o.OrderStatus FROM rsung_view_index_cart c INNER JOIN (SELECT OrderID, OrderSN, OrderStatus FROM rsung_order_orderinfo WHERE OrderCompany = 28 AND OrderStatus != 8 AND OrderStatus != 9) AS o ON c.OrderID = o.OrderID WHERE c.CompanyID = 28 ORDER BY c.ID DESC limit 10; 修改为 ： SELECT i.Coding, i.Units, c.ID, c.OrderID, c.ClientID, c.ContentID, c.ContentName, c.ContentColor, c.ContentSpecification, c.ContentPrice, c.ContentNumber, c.ContentPercent, c.ContentSend, o.OrderSN, o.OrderStatus FROM rsung_order_cart c LEFT JOIN rsung_order_content_index i ON c.ContentID=i.ID and i.coding = ‘107894’ LEFT JOIN rsung_order_orderinfo o ON AND o.OrderStatus != 9 WHERE c.CompanyID = 226 ORDER BY c.ID DESC LIMIT 0,50;  c.OrderID = o.OrderID AND o.OrderStatus != 8 SQL 取得行数 select @aa:=@aa+1 from rsung_order_cart c,(select @aa:=0) s limit 20; 2015-10-14: Replace into  与 insert  ignore  与  insert  ...  On duplicate  key update... REPLACE  的运行与  INSERT  很相似。只有一点例外，  假如表中的一个旧记录与一个用于  PRIMAR Y KEY 或一个 UNIQUE 索引的新记录具有相同的值，则在新记录被插入之前，旧记录被删除。 注意，除非表有一个 PRIMARY KEY 或 UNIQUE 索引，否则，使用一个 REPLACE 语句没有意义。 该 语句会与 INSERT 相同，因为没有索引被用于确定是否新行复制了其它的行。 db_dhb_hk 和 db_dhb_hk_1 和 db_dhb_hk_2 ==== 原SQL ： select s.*,o.OrderID,o.OrderSN,c.ClientID,c.ClientCompanyName FROM rsung_order_ordersubmit s inner join rsung_order_orderinfo o on s.OrderID=o.OrderID inner join rsung_order_client c ON c.ClientID=o.OrderUserID where c.ClientCompany=210 and s.CompanyID=210 and s.Status=客户留言 and o.OrderCompany=210 and s.Date 1444060800 ORDER BY s.ID DESC limit 0,20; . * , o.OrderID, o.OrderSN, c.ClientID, c.ClientCompanyName FROM rsung_order_ordersubmit s FORCE INDEX ( idx_CompanyID_date ) INNER JOIN rsung_order_orderinfo o ON s.OrderID = o.OrderID AND o.OrderCompany =28 INNER JOIN rsung_order_client c