>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