有以下SQL语句:
SELECT A.ZJD,A.XM,A.JD,A.ZH ,A.b1,A.XB,
C.b1 as C1,
C.b2 as C2,
C.b3 as C3,
D.b1 as D1,
D.b2 as D2,
D.b3 as D3,
E.b1 as E1,
E.b2 as E2,
E.b3 as E3,
F.b1 as F1,
F.b2 as F2,
F.b3 as F3,
G.b1 as G1,
G.b2 as G2,
G.b3 as G3,
H.b1 as H1,
H.b2 as H2,
H.b3 as H3,
I.b1 as I1,
I.b2 as I2,
I.b3 as I3,
J.b1 as J1,
J.b2 as J2,
J.b3 as J3
FROM tab1 AS A LEFT JOIN tab2 AS B ON A.b1=B.b1
LEFT JOIN tab3 AS C ON B.b1=C.b1
LEFT JOIN tab4 AS D ON B.b1=D.b1
LEFT JOIN tab5 AS E ON B.b1=E.b1
LEFT JOIN tab6 AS F ON B.b1=F.b1
LEFT JOIN tab7 AS G ON B.b1=G.b1
LEFT JOIN tab8 AS H ON B.b1=H.b1
LEFT JOIN tab9 AS I ON B.b1=I.b1
LEFT JOIN tab10 AS J ON B.b1=J.b1
WHERE
NOT (C.b1 IS NULL) AND
(J.b1 IS NULL OR J.b3='9')问题:
在VB程序中利用ADO执行以上SQL语句,速度是相当的慢,不知道的,还以为是死机了,而且硬盘灯也不是常闪;但在SQL SERVER中的Query Analyzer中执行,则速度相当的快,这是什么原因??怎么解决??/
SELECT A.ZJD,A.XM,A.JD,A.ZH ,A.b1,A.XB,
C.b1 as C1,
C.b2 as C2,
C.b3 as C3,
D.b1 as D1,
D.b2 as D2,
D.b3 as D3,
E.b1 as E1,
E.b2 as E2,
E.b3 as E3,
F.b1 as F1,
F.b2 as F2,
F.b3 as F3,
G.b1 as G1,
G.b2 as G2,
G.b3 as G3,
H.b1 as H1,
H.b2 as H2,
H.b3 as H3,
I.b1 as I1,
I.b2 as I2,
I.b3 as I3,
J.b1 as J1,
J.b2 as J2,
J.b3 as J3
FROM tab1 AS A LEFT JOIN tab2 AS B ON A.b1=B.b1
LEFT JOIN tab3 AS C ON B.b1=C.b1
LEFT JOIN tab4 AS D ON B.b1=D.b1
LEFT JOIN tab5 AS E ON B.b1=E.b1
LEFT JOIN tab6 AS F ON B.b1=F.b1
LEFT JOIN tab7 AS G ON B.b1=G.b1
LEFT JOIN tab8 AS H ON B.b1=H.b1
LEFT JOIN tab9 AS I ON B.b1=I.b1
LEFT JOIN tab10 AS J ON B.b1=J.b1
WHERE
NOT (C.b1 IS NULL) AND
(J.b1 IS NULL OR J.b3='9')问题:
在VB程序中利用ADO执行以上SQL语句,速度是相当的慢,不知道的,还以为是死机了,而且硬盘灯也不是常闪;但在SQL SERVER中的Query Analyzer中执行,则速度相当的快,这是什么原因??怎么解决??/
set abc=new adodb.recordset
abc.open sqlstr,conn,1,3
运行Open是,就很慢,其他语句代码都正常呀