hehongping 发表于 2012-11-07 11:17

Sybase 优化性能的问题

执行如下SQL   ：   insert into st_userflow_all_1440_20121102(sttime,hh,mi,srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid,
                        recvpacket,sendpacket,recvoct,sendoct,alloct,delays,users,sendlosspkt,recvlosspkt,sendretranspkt,recvretranspkt,termdelay,netdelay
                        )
                        select dateformat(sttime,''yyyy-mm-dd'')||'' 00:00:00'' st,0 hh,0 mi,srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid,
                        sum(recvpacket),sum(sendpacket),sum(recvoct),sum(sendoct),sum(alloct),sum(delays),sum(users),sum(sendlosspkt),
                        sum(recvlosspkt),sum(sendretranspkt),sum(recvretranspkt),sum(termdelay),sum(netdelay)
                        from st_userflow_all_60_20121102 a
                        group by dateformat(sttime,''yyyy-mm-dd'')||'' 00:00:00'',srcid,desid,lacid,sac,imsi,msisdn,imei,hlr,interfacetype,rattype,serviceid,areaid
总共有45460682条记录，花了两个小时40分钟，问下有什么优化策略没？数据库是Sybase 12.7 IQ。非常谢谢

zhaopingzi 发表于 2012-11-07 12:20

为什么不用load呢，insert当然慢
页: [1]
查看完整版本: Sybase 优化性能的问题