>>> snipped
>
>>If, first run, you execute this:
>>
>>SYS(3054,11)
>>SELECT * FROM tacust WHERE tacust.cmrno = 0 AND tacust.actflag = "1"
>>
>>* or
>>
>>
>>USE tacust .... ORDER cmrnoTAG
>>COUNT
>>SYS(3054,11)
>>SELECT * FROM tacust WHERE tacust.cmrno = 0 AND tacust.actflag = "1"
>>
>>
>>FABIO
>
>Hello Fabio,
>
>Thanks, I tried both (had to re-boot to try the 2nd one), it took ~3 minutes then 1-2 seconds after that, just like the view. Hmm...
How much time demands one direct opening and scan?:
t1=seconds()
USE tacust SHARED
? 'open header',seconds()-t1
t1=seconds()
scan
endscan
? 'first scan',seconds()-t1
t1=seconds()
scan
endscan
? 'second scan',seconds()-t1