我的数据库中有一个表
表结构
ZAZHIMC char no 100
BIANMA char no 20
PINYIN varchar no 100
XINGMING char no 40
XINGBIE char no 2
CHUSHENGRQ datetime no 8
XUEKELEI char no 40
ZHUANYELEI char no 200
DANWEI varchar no 200
TONGXINDZ varchar no 200
YOUZHENGBM char no 6
DIANHUA varchar no 50
E_MAIL varchar no 150
RENYUANLEI char no 20
FENLEI char no 20
BEIZHU text no 16
PROVINCE varchar no 40
UID varchar no 20
UPassWord varchar no 20
ZhiWu varchar no 20
ZhiCheng varchar no 20
ZhaoPian image no 16
ZhaoPianLX char no 10
Fax varchar no 30
Ming char no 100
Xing char no 100
TongXinDZDZ varchar no 500
DanWeiXingZhi varchar no 40
DaoShi varchar no 500
XueSheng varchar no 500
YuYan varchar no 30
ZhaoShengXX text no 16
ShenGaoSD varchar no 20
ShenGaoTD varchar no 20
DingYueEmail char no 2
HTTP varchar no 200
Country varchar no 200
索引
IDX_XINGMING_CLUSTER clustered located on PRIMARY ZAZHIMC, RENYUANLEI
IDX_XINGMING_UNIQUE nonclustered, unique located on PRIMARY ZAZHIMC, RENYUANLEI, XINGMING
SQL语句:
select ZAZHIMC,BIANMA,PINYIN,XINGMING,XINGBIE,CHUSHENGRQ,XUEKELEI,ZHUANYELEI,DANWEI,TONGXINDZ,YOUZHENGBM,DIANHUA,E_MAIL,RENYUANLEI,FENLEI,BEIZHU,PROVINCE,UID,UPassWord,ZhiWu,ZhiCheng,Fax,Ming,Xing,TongXinDZDZ,DanWeiXingZhi,ShenGaoTD,ShenGaoSD,DaoShi,XueSheng,YuYan,ZhaoShengXX,DingYueEmail,HTTP,Country from RENYUANXX
where RENYUANLEI="作者"
order by DANWEI,XINGMING我在程序中用DBedit,DBmemo等数据库控见显示用query(requestlive=true)选出的记录集
并用DBNavigator1控制字段的操作,但是当我第一次打开窗体(query.Open),修改一个字段值,并用DBNavigator1来post的时侯很慢,post进去以后,再Post就很快了,请问这是怎么回事,我已经Delphi编程两年了还是不知怎么回事!请知道的人指点一下好吗?
表结构
ZAZHIMC char no 100
BIANMA char no 20
PINYIN varchar no 100
XINGMING char no 40
XINGBIE char no 2
CHUSHENGRQ datetime no 8
XUEKELEI char no 40
ZHUANYELEI char no 200
DANWEI varchar no 200
TONGXINDZ varchar no 200
YOUZHENGBM char no 6
DIANHUA varchar no 50
E_MAIL varchar no 150
RENYUANLEI char no 20
FENLEI char no 20
BEIZHU text no 16
PROVINCE varchar no 40
UID varchar no 20
UPassWord varchar no 20
ZhiWu varchar no 20
ZhiCheng varchar no 20
ZhaoPian image no 16
ZhaoPianLX char no 10
Fax varchar no 30
Ming char no 100
Xing char no 100
TongXinDZDZ varchar no 500
DanWeiXingZhi varchar no 40
DaoShi varchar no 500
XueSheng varchar no 500
YuYan varchar no 30
ZhaoShengXX text no 16
ShenGaoSD varchar no 20
ShenGaoTD varchar no 20
DingYueEmail char no 2
HTTP varchar no 200
Country varchar no 200
索引
IDX_XINGMING_CLUSTER clustered located on PRIMARY ZAZHIMC, RENYUANLEI
IDX_XINGMING_UNIQUE nonclustered, unique located on PRIMARY ZAZHIMC, RENYUANLEI, XINGMING
SQL语句:
select ZAZHIMC,BIANMA,PINYIN,XINGMING,XINGBIE,CHUSHENGRQ,XUEKELEI,ZHUANYELEI,DANWEI,TONGXINDZ,YOUZHENGBM,DIANHUA,E_MAIL,RENYUANLEI,FENLEI,BEIZHU,PROVINCE,UID,UPassWord,ZhiWu,ZhiCheng,Fax,Ming,Xing,TongXinDZDZ,DanWeiXingZhi,ShenGaoTD,ShenGaoSD,DaoShi,XueSheng,YuYan,ZhaoShengXX,DingYueEmail,HTTP,Country from RENYUANXX
where RENYUANLEI="作者"
order by DANWEI,XINGMING我在程序中用DBedit,DBmemo等数据库控见显示用query(requestlive=true)选出的记录集
并用DBNavigator1控制字段的操作,但是当我第一次打开窗体(query.Open),修改一个字段值,并用DBNavigator1来post的时侯很慢,post进去以后,再Post就很快了,请问这是怎么回事,我已经Delphi编程两年了还是不知怎么回事!请知道的人指点一下好吗?
还有就是最好用Update语句来更新数据
所以,我個人認為,這個是sql server本身的原因,和程序沒有直接關係.