General information
Category:
Coding, syntax & commands
>oh oh !
>
>
> *-- Buffe1 0.109
> *-- Buffe5 0.188
>
>it is the same time !
And then where is the tip benefit.
It exists if you want update multiple times
the same records, but for a one shot update
i'm not sure.
Hi.
>
>>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only