bBrowser and SQLTable - Delay due to auto refresh when using mouse.

Stavros Spanos · Post by **Stavros Spanos** » Tue Aug 23, 2022 10:36 am

Video reproducing the issue:

http://www.youtube.com/watch?v=qfj46qTHN_8

Joachim hello again!

The video describes the delay of using the bBrowser when we click using the mouse, while if we just press Up or Down key all work fine (in this case there is line re-read when moving from one record to the other.

DESCRIPTION
*****************

- We have a bBrowser control on a DataWindow.
- We have a SQLTable as the DataWindow:Server.
- This SQLTable is the data source for the bBrowser control.

Due to the complexity of the column content of the SQLTable, we experience very serious delay when moving from one row to another.
We suspect that this is due to the data refresh that the control is performing.

(We tested that if we chang any data ok the DQL server bBrowser is refreshed automatically on record change - good in general but NOT in our case..)

If we suspend the bBrowser control ( e.g. SELF:oDCList:SuspendNotification() ) unfortunatelly there is no movement from one row to another at all and the browser freezes..

Is there a way to avoid this "refreshing" when moving from one row to another ? What we need is the behaviour the bBrowser has when pressing the arrows on the keyboard - but when we use the mouse.

g.bunzel@domonet.de · Post by **g.bunzel@domonet.de** » Sun Aug 28, 2022 4:48 pm

Stavros,

if you move with the arrow keys, your 'Property's brief description' will be showed with a little delay time. But with a mouse click, that text changes immedialtely. Please show some code of the Methods 'Notify' and 'CellClick' and 'EventHandler' and something else, who changes that 'Property's brief description'.
For a little test, please disable/remove that update for the 'Property's brief description'.

Regards

Gerhard

Stavros Spanos · Post by **Stavros Spanos** » Sun Aug 28, 2022 9:10 pm

Thanks for the advice. "Property brief description" ON/OFF does no affect the perofmance significally - we have allready tesed it. The delay is beacuse we redraw this field with code AFTER the record move. On the other hand when we use arrow keys the value of the line IS NOT UPDATED! That is why there is no actual delay on this record move.

I'm afraid it's a switch we need from Joachim - or some setting i'm not aware of...