2,496
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
fengwenhua 2004-10-21
- 打赏
- 举报
同意 GoldShield(小花☆正直人)兄的说法
query.Prepare;的大致意思是要服务器为QUERY准备好资源如内存空间之类的!
UnPrepare大致就是让服务器断开这些服务.
query.Prepare;的大致意思是要服务器为QUERY准备好资源如内存空间之类的!
UnPrepare大致就是让服务器断开这些服务.
ghchen 2004-10-21
- 打赏
- 举报
推荐使用
GoldShield 2004-10-20
- 打赏
- 举报
我觉的query.Prepare；可以提高sql语句的执行效率
..................
服务器在执行Prepare时会对查询进行优化并保存,所以上面的E文中不是也说了么,如果你的查询只执行一次的话大可不必使用Prepare
..................
服务器在执行Prepare时会对查询进行优化并保存,所以上面的E文中不是也说了么,如果你的查询只执行一次的话大可不必使用Prepare
blackblue123 2004-10-20
- 打赏
- 举报
我觉的query.Prepare；可以提高sql语句的执行效率
兵兵 2004-10-20
- 打赏
- 举报
同意 GoldShield(小花☆正直人)兄的说法
GoldShield 2004-10-20
- 打赏
- 举报
query.Prepare;的大致意思是要服务器为QUERY准备好资源如内存空间之类的并把QUERY中的语句先行编译成服务器执行的语句格式.
UnPrepare大致就是让服务器断开这些服务.
UnPrepare大致就是让服务器断开这些服务.
wycg_cnh20 2004-10-20
- 打赏
- 举报
Delphi Help:
=========================================================================================
Call Prepare to have the BDE and a remote database server allocate resources for the query and to perform additional optimizations. Preparing a query consumes some database resources, so it is good practice to call UnPrepare once the query is no longer needed.
If the query will only be executed once, the application does not need to explicitly call Prepare or UnPrepare. Executing an unprepared query generates these calls automatically. However, if the same query is to be executed repeatedly, it is more efficient to prevent these automatic calls by calling Prepare and UnPrepare explicitly.
=========================================================================================
if not Query1.Prepared then
begin
Query1.Close;
Query1.Prepare;
Query1.Open;
end;
=========================================================================================
Call Prepare to have the BDE and a remote database server allocate resources for the query and to perform additional optimizations. Preparing a query consumes some database resources, so it is good practice to call UnPrepare once the query is no longer needed.
If the query will only be executed once, the application does not need to explicitly call Prepare or UnPrepare. Executing an unprepared query generates these calls automatically. However, if the same query is to be executed repeatedly, it is more efficient to prevent these automatic calls by calling Prepare and UnPrepare explicitly.
=========================================================================================
if not Query1.Prepared then
begin
Query1.Close;
Query1.Prepare;
Query1.Open;
end;
