Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #13567 > unrolled thread
| Started by | Stavros Spanos <stavros.spanos2@gmail.com> |
|---|---|
| First post | 2022-03-04 07:19 -0800 |
| Last post | 2022-03-08 07:47 -0800 |
| Articles | 6 — 4 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
bBrowser and SQL delay question Stavros Spanos <stavros.spanos2@gmail.com> - 2022-03-04 07:19 -0800
Re: bBrowser and SQL delay question Jamal <nospam@example.com> - 2022-03-04 16:53 -0500
Re: bBrowser and SQL delay question Stavros Spanos <stavros.spanos2@gmail.com> - 2022-03-08 00:59 -0800
Re: bBrowser and SQL delay question Stefan Ungemach <stefan.ungemach@bingo-ev.de> - 2022-03-08 04:48 -0800
Re: bBrowser and SQL delay question Jamal <nospam@example.com> - 2022-03-08 12:59 -0500
Re: bBrowser and SQL delay question dlzc <dlzc1@cox.net> - 2022-03-08 07:47 -0800
| From | Stavros Spanos <stavros.spanos2@gmail.com> |
|---|---|
| Date | 2022-03-04 07:19 -0800 |
| Subject | bBrowser and SQL delay question |
| Message-ID | <ef615acd-f046-4fd4-b56f-07254e751726n@googlegroups.com> |
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!
[toc] | [next] | [standalone]
| From | Jamal <nospam@example.com> |
|---|---|
| Date | 2022-03-04 16:53 -0500 |
| Message-ID | <svu1p9$4q3$1@dont-email.me> |
| In reply to | #13567 |
Make sure bBrowser:AutoRefreshTime = 0 and bBrowser:ServerType set to #SQL. From the docs: The bBrowser optimizes the access to the data server depending on the server type. Jamal On 3/4/2022 10:19 AM, Stavros Spanos wrote: > 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!
[toc] | [prev] | [next] | [standalone]
| From | Stavros Spanos <stavros.spanos2@gmail.com> |
|---|---|
| Date | 2022-03-08 00:59 -0800 |
| Message-ID | <95426251-7169-48e5-a709-9e7492d3bc4an@googlegroups.com> |
| In reply to | #13568 |
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
[toc] | [prev] | [next] | [standalone]
| From | Stefan Ungemach <stefan.ungemach@bingo-ev.de> |
|---|---|
| Date | 2022-03-08 04:48 -0800 |
| Message-ID | <4eadebac-7abd-4e8a-800e-67c5c58f6bb1n@googlegroups.com> |
| In reply to | #13570 |
stavros...@gmail.com schrieb am Dienstag, 8. März 2022 um 09:59:22 UTC+1: > 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 Have you tried working with a timer? I.e. overwriting bBrowser:Notify, redirect NOTIFYRECORDCHANGE to some killtimer/settimer construct and calling super:Notify() via the Dispatch method of your subclassed bBrowser (for the appropriate WM_TIMER message). That would decouple all internal logic for a moment. Problem is the refresh of the selection, but you could at least start playing around in that direction.
[toc] | [prev] | [next] | [standalone]
| From | Jamal <nospam@example.com> |
|---|---|
| Date | 2022-03-08 12:59 -0500 |
| Message-ID | <t085hp$on$1@gioia.aioe.org> |
| In reply to | #13570 |
Try using bBrowser:SuspendNotification() in the PostInit() method, then when you want to refresh, issue bBrowser:ResestNotification(), then bBrowser:Refresh(), then suspend again. Since notification calls are stacked, you may want to keep track via a variable if SuspendNotification is still active, because on Window close, you need to ResetNotification. HTH, Jamal On 3/8/2022 3:59 AM, Stavros Spanos wrote: > 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
[toc] | [prev] | [next] | [standalone]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2022-03-08 07:47 -0800 |
| Message-ID | <6d7b7ba9-b497-4426-9cb4-10b0b286308bn@googlegroups.com> |
| In reply to | #13567 |
On Friday, March 4, 2022 at 8:19:33 AM UTC-7, stavros...@gmail.com wrote: > 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). Load the displayed fields, and a record number in a short table / array. Browse the "static" table, rather then the full DBF, record by record. Only call SQL to load / reload the table, when delays are expected. Do not allow editing of a record in the columnar display (unless you want to handle that). "Doctor, it hurts when I do this!" David A. Smith
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web