一个查询按钮下面有35页(word文件)那么长的代码,其中有
数不尽的类似“str_sfy1 := select ... from ..."
"str_sfy3 := Str_sfy2+'order by ...';
"Str_sk=Str_sk+'group by ...."
with Q... do
begin
close;
sql.clear;
sql.add("insert into ...")
end;因为查询效率较低,老板叫我优化这些代码,怎么办? 代码量太大,业务又不熟(刚来差不多一个星期)都想不干了...郁闷...
数不尽的类似“str_sfy1 := select ... from ..."
"str_sfy3 := Str_sfy2+'order by ...';
"Str_sk=Str_sk+'group by ...."
with Q... do
begin
close;
sql.clear;
sql.add("insert into ...")
end;因为查询效率较低,老板叫我优化这些代码,怎么办? 代码量太大,业务又不熟(刚来差不多一个星期)都想不干了...郁闷...
或者用存储过程,方法很多种
我想这样子效果会比较好,老板会认同你的。。
good luck!
good luck!