oh oh !


*-- Buffe1 0.109
*-- Buffe5 0.188

it is the same time !


>>a lttle change...
>>
>>
>>SET SECONDS ON
>> SET MULTILOCKS OFF
>> CURSORSETPROP("Buffering" ,1,"Resident")
>> timestart1=SECONDS()
>>
>> UPDATE Resident ;
>> SET NoitelephoneIdReportActif ;
>> = NVL((SELECT F.ireport FROM cFiltre F WHERE F.itelephoneid=Resident.itelephoneid AND F.ireport = NoReport),0)
>>
>> SELECT Resident
>> * =TABLEUPDATE(.T.)
>> SET MULTILOCKS ON
>> CURSORSETPROP("Buffering" ,5,"Resident")
>> Buffe1 = SECONDS()-timestart1
>>
>>
>> timestart5=SECONDS()
>> UPDATE Resident ;
>> SET NoitelephoneIdReportActif ;
>> = NVL((SELECT F.ireport FROM cFiltre F WHERE F.itelephoneid=Resident.itelephoneid AND F.ireport = NoReport),0)
>>
>> Buffe5 = SECONDS()-timestart5
>>
>> *-- Buffe1 0.110
>> *-- Buffe5 0.047
>>
>
>And if you swap the operaions, and do buffer 5 before ?
>( for exclude a cache effect )
>
>thanks