create view v1 as
select a.c1, a.c2, ... cast(b.c1 as varchar(10)) + cast(b.c2 as varchar(10) + ... as btable
from table1 as a left join table2 as b on a.id = b.id
select a.c1, a.c2, ... cast(b.c1 as varchar(10)) + cast(b.c2 as varchar(10) + ... as btable
from table1 as a left join table2 as b on a.id = b.id
... cast(b.c1 as varchar(10)) +'***'+ cast(b.c2 as varchar(10) ...
delphi里面开发三层,如果先在中间层里面设定主从关系,在客户端里用两个TDataClientSet链接,速度很慢,怎么解决?