Hi all!!
We are using a data bounded bBrowser connected with a VO SQLTable that handles a lot of data, code blocks etc.
When we are moving from row to row (with mouse or keys), it seems that a data refreshing is going on, concerning the current record (actually the records seems to be re-read from original SQL Server when we move to it).
This of course is very nice, but causes a delay of 2-3 second while we are browsing.
We have 2 questions:
• Is there a way to work more asynchronously? We need to browse without any interaction with the server and <Refresh All> when needed. Is there a way to do this?
• Is there a – kind of – “granularity” concerning thw interaction between SQL Server / SQLTable / bBrowser?? It seems like the problem gets worse with Tables with 50000-100000 rows.
Thanks in advance!
Thanks for the reply Jamal!
Unfortunatelly we do not need an Autorefresh(off). It is anyway by default. Our problem is that the bBrowser autamatically re-reads the current record from the SQLTable every time the current row changes (f.e. when clicking another row).
We want this behaviour to stop because it leads to 2-3 seconds delay, something that confuses the user when browsing. So in a way we need to make the bBrowser work like "disconnected" to the Server.
Stavros
Hi all!!
We are using a data bounded bBrowser connected with a VO SQLTable that handles a lot of data, code blocks etc.
When we are moving from row to row (with mouse or keys), it seems that
a data refreshing is going on, concerning the current record (actually the records seems to be re-read from original SQL Server when we move to it).
Thanks for the reply Jamal!
Unfortunatelly we do not need an Autorefresh(off). It is anyway by default. Our problem is that the bBrowser autamatically re-reads the current record from the SQLTable every time the current row changes (f.e. when clicking another row).
We want this behaviour to stop because it leads to 2-3 seconds delay, something that confuses the user when browsing. So in a way we need to make the bBrowser work like "disconnected" to the Server.
Stavros
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 299 |
Nodes: | 16 (2 / 14) |
Uptime: | 55:18:37 |
Calls: | 6,690 |
Files: | 12,225 |
Messages: | 5,345,000 |