Changes between Initial Version and Version 1 of Ticket #117


Ignore:
Timestamp:
10/18/2012 03:01:48 PM (13 years ago)
Author:
huangzhong
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #117 – Description

    initial v1  
    22应用上线后，功能检查一切正常，突然1点数据库负载变高，去到了4左右，让dba抓了下慢语句，发现大量类似如下的SQL语句 
    33{{{ 
     4 
    45SELECT t0.IMG1, t0.IMG2, t0.IMG3, t1.id, t1.BIG_PIC_PATH, t1.BRAND_NAME, t1.LAST_COUNT_ORDER, t1.CREATE_DATE, t1.FORUM_PATH, t1.HOT_NEW, t1.MID_PATH, t1.name, t1.ORDER_KEY, t1.price, t1.PRICE_CONFIG, t1.PUB_URL, t1.REVIEW_STATUS, t1.SHORT_NAME, t1.PIC_PATH, t1.SMALLTYPE_ID, t1.TYPE_ID, t1.VARIANCE_ID FROM ENT_PRODUCT t0 LEFT OUTER JOIN V_PDL_PRODUCT t1 ON t0.PRODUCT_ID = t1.id WHERE t0.id = $1 
     6 
    57}}} 
    68