我用的是sqlserver的数据库,在程序中我对一个视图进行查询,很简单的一个查询语句:select * from V_PGJG where stid='010101000001';其中视图V_PGJG是:CREATE VIEW rsttk.V_PGJG
AS
SELECT T_PGJG.stid, T_STTK.ysnycd, T_NYCD.name AS ysnycdname, T_PGJG.sjdh,
T_PGJG.zf, T_PGJG.yxl, T_PGJG.tgl, T_PGJG.lsd, T_PGJG.qfd, T_PGJG.nycd,
T_PGJG.pjf, T_SJDZ.sjname, T_SJDZ.zjsj, T_SJDZ.zjfs, T_SJDZ.sjkm, T_SJDZ.sjckrs,
T_SJDZ.sjpjf, T_SJDZ.sjzf, T_SJDZ.sjnd, T_SJDZ.kssj, T_SJDZ.complate,
T_SJDZ.sjxz, T_SJDZ.about, T_SJDZ.lasttime, T_SJDZ.totaltimes, T_SJDZ.sjinfor,
T_SJDZ.yshgl, T_SJDZ.klbl, T_SJDZ.mtyq, T_SJDZ.kmname
FROM T_PGJG INNER JOIN
T_STTK ON T_PGJG.stid = T_STTK.stid INNER JOIN
T_NYCD ON T_STTK.ysnycd = T_NYCD.code INNER JOIN
T_SJDZ ON T_PGJG.sjdh = T_SJDZ.sjcode;这个查询语句在query analyzer中查询速度很快,可在程序中就很慢,希望各位大侠能够指导一二
AS
SELECT T_PGJG.stid, T_STTK.ysnycd, T_NYCD.name AS ysnycdname, T_PGJG.sjdh,
T_PGJG.zf, T_PGJG.yxl, T_PGJG.tgl, T_PGJG.lsd, T_PGJG.qfd, T_PGJG.nycd,
T_PGJG.pjf, T_SJDZ.sjname, T_SJDZ.zjsj, T_SJDZ.zjfs, T_SJDZ.sjkm, T_SJDZ.sjckrs,
T_SJDZ.sjpjf, T_SJDZ.sjzf, T_SJDZ.sjnd, T_SJDZ.kssj, T_SJDZ.complate,
T_SJDZ.sjxz, T_SJDZ.about, T_SJDZ.lasttime, T_SJDZ.totaltimes, T_SJDZ.sjinfor,
T_SJDZ.yshgl, T_SJDZ.klbl, T_SJDZ.mtyq, T_SJDZ.kmname
FROM T_PGJG INNER JOIN
T_STTK ON T_PGJG.stid = T_STTK.stid INNER JOIN
T_NYCD ON T_STTK.ysnycd = T_NYCD.code INNER JOIN
T_SJDZ ON T_PGJG.sjdh = T_SJDZ.sjcode;这个查询语句在query analyzer中查询速度很快,可在程序中就很慢,希望各位大侠能够指导一二
解决方案 »
- delphi7 与access2007
- 先在delphi7里装了raize5,之后在delphi6里装了raize4.1安装的raize的分别在不同的文件夹里,可是在Delphi6里出现版本错误
- *** 看是delphi板块 和 VC板块 哪个先解决: 用VC读取别人的delphi程序的控件的name属性.
- 难啊,解决不了的问题,有什么控件可以手动选择的增加和删除一条记录的显示,
- 高手看看这个问题是不是没有解决的方法????????
- 谁有办法改过来吗,谢谢
- 关于default引起的错误
- 用delphi开发asp组件,如何调试啊??痛苦中……
- delphi XE2自带皮肤导致treeview的滚动条失焦问题怎样解决
- 在delphi中怎样注册一个ocx控件,用代码如何实现!!!
- 我前天问过这个问题,不过我还是会出现这种错误,请帮我看看。
- 帮忙!!!!!!!!!
只要改成clUseServer,速度简直提高1000倍(对于离线数据库的letters),绝不比BDE慢,
CursorType具体说明看看help就可以了,虽然号称两种各有优劣,
但一般来讲用clUseServer应该是正确选择,没必要使用clUseClient。