就这些分，请人帮忙看看这段sql代码
create proc Depth
as
declare @Count int ,@Date datetime,@CountIp varchar(200),@Depth int
DECLARE Flow_CUR CURSOR FOR
select subString(CONVERT(varchar, CountTime, 120 ),0,CHARINDEX( ': ',CountTime))+ ':00:00 ' as Date,
CountIp,count(CountUrl) as Depth
from Count_ReturnAndDepth where CustomerID= '1 'and StatisticsDepthOrFalse=2 group by CountIp,
subString(CONVERT(varchar, CountTime, 120 ),0,CHARINDEX( ': ',CountTime))+ ':00:00 ',HostName
OPEN Flow_CUR
fetch next from Flow_CUR into @Date,@CountIp,@Depth
WHILE (@@FETCH_STATUS) = 0
BEGIN
select @Count=DepthCount from Count_DepthInformation where CustomerID= '1 'and CountIP=@CountIp and PostTime=@Date
if exists(select 1 from Count_DepthInformation where CustomerID= '1 'and CountIP=@CountIp and
PostTime=@Date)update Count_DepthInformation set DepthCount=1 +@Count where CustomerID= '1 '
and CountIP=@CountIp and PostTime=@Date
else insert into Count_DepthInformation (CustomerID,CountIp,DepthCount,PostTime)
values ( '1 ',@CountIp, '1 ',@Date)
FETCH NEXT FROM Flow_CUR into @Date,@CountIp,@Depth
END
CLOSE Flow_CUR
DEALLOCATE Flow_CUR
Update Count_ReturnAndDepth set StatisticsDepthOrFalse=1 where StatisticsDepthOrFalse=0
----------------------------------------------------
在做一个流量的统计，关系到两个表，我使用游标测试时，速度超慢，4000条要运行2分多钟，不知道能不能使用其他办法改进，请大家帮忙看看，谢谢！！
[解决办法]
自己先测一下是哪步引起效率极低的吧，根据测试结果来更改一些主要的内容。
比如先测一下
SELECT CONVERT(CHAR(13), CountTime, 120 )+ ':00:00 ' AS Date,CountIp,COUNT(1) AS Depth
FROM Count_ReturnAndDepth
WHERE CustomerID= '1 'AND StatisticsDepthOrFalse=2
GROUP BY CountIp,Date,HostName
--看看耗时多久。
如果耗时长的话想办法优化此句。
[解决办法]
up
