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





>>Fabio,
>>
>>Bingo !
>>
>>This solution is very nice !
>
>>
>>great Thank....
>>
>You're welcome.
>
>bernhart, can you give me this info ?
>
>

>timestart=seconds()
>-- set buffer
>-- UPDATE
>-- TABLEUPDATE
>wait windows seconds()-timestart
>

>
>

>timestart=seconds()
>set no buffer
>UPDATE
>wait windows seconds()-timestart
>

>
>Which is faster ?