Incredible but true ....;)

bernhart

 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
  Buffe1 =  SECONDS()-timestart1

  CURSORSETPROP("Buffering" ,5,"Resident")
  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.828
*-- 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 ?