.net调用sql语句时巨慢怎么回事

[shishui508]

把sql拷到sqlserver08上执行，不到一秒钟，结果就出来了，
但在.net程序里一调就超时。快晕了

select a.code,a.name,a.registdate,a.llimit,a.slimit,sum(lDel) lDel,sum(sDel) sDel,sum(LModify) LModify,sum(LRef) LRef,
sum(addlref) addlref,sum(ladd) ladd,sum(ladd+LRef+LModify+addlref) LRefCount,sum(lcurrent) lcurrent,
sum(lcount) lcount,sum(b.hit) leasehit,sum(Saleref) SaleRef,sum(saleModify) SaleModify,sum(addsautoref) AddSautoRef,sum(saleadd) saleadd,
sum(sadd+sref+smodify+addsref) SRefCount,sum(scurrent) scurrent,sum(scount) scount,sum(c.hit) shit 
from mlscomprep a left join mlslrep b on a.code=b.code and CONVERT(varchar(12),a.REGISTDATE,110)=CONVERT(varchar(12),b.hitdate,110)  
left join mlssrep c on a.code=c.code and CONVERT(varchar(12),a.REGISTDATE,110)=CONVERT(varchar(12),c.hitdate,110) 
where a.code in(101001501,101001554,101001552,101001550,101001629,101001570,101002750,101001535) and a.registdate>=CONVERT(varchar(12),getdate()-1,110) and a.registdate<CONVERT(varchar(12),getdate(),110) 
group by a.code,a.name,registdate,a.llimit,a.slimit order by name,registdate

就是运算有点多，是什么原因呢？

[billpu]

.net 的问题?

[wgsasd311]

可以把它放到存储过程，然后程序再调用存储过程。

[SQL77]

.NET调用当然啦,这么多连接,计算列,加索引或用视图试试

[--小F--]

放到存储过程来调用是王道

[souperstar]

推荐存储过程~~

[soft_wsx]

用过程试一下先！.net是在远程还是本地还是局域网！

[幸运的意外]

计算太多,数据量大,都会影响到速度打了.