1、修改为CHRTRAN后,速度确实提高;
2、测试一下下面代码,虽然比SQL语句代码多一点,似乎速度
更快一些
t1=SECONDS()
cLEAR
CLEAR ALL
SET SAFETY OFF
t1=SECONDS( )
STRTOFILE(CHRTRAN(FILETOSTR("d:\zz\数据.sed")," ",CHR(13)),"d:\zz\temp8.txt")
CREATE CURSOR sed(n1 c(12))
APPEND FROM d:\zz\temp8.txt SDF
SELECT *,RECNO() as jl,CEILING(RECNO()/4) as bz FROM sed INTO ARRAY zz1
ff=ALEN(zz1,1)
ff2=IIF(ff/4=INT(ff/4),ff/4,INT(ff/4)+1)
PUBLIC array zz2(ff2,4)
ff1=zz1(1,3)
j=1
FOR i=1 TO ff
j=IIF(ff1<>zz1(i,3),j+1,j)
ff1=IIF(ff1<>zz1(i,3),zz1(i,3),ff1)
ttf1=IIF(MOD(zz1(i,2),4)=0,4,MOD(zz1(i,2),4))
zz2(j,ttf1)=zz1(i,1)
ENDFOR
CREATE CURSOR ddq(n1 c(12),n2 c(12),n3 c(12),n4 c(12))
APPEND FROM ARRAY zz2
?SECONDS()-t1