Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13567 > unrolled thread

bBrowser and SQL delay question

Started byStavros Spanos <stavros.spanos2@gmail.com>
First post2022-03-04 07:19 -0800
Last post2022-03-08 07:47 -0800
Articles 6 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#13567 — bBrowser and SQL delay question

FromStavros Spanos <stavros.spanos2@gmail.com>
Date2022-03-04 07:19 -0800
SubjectbBrowser 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]


#13568

FromJamal <nospam@example.com>
Date2022-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]


#13570

FromStavros Spanos <stavros.spanos2@gmail.com>
Date2022-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]


#13571

FromStefan Ungemach <stefan.ungemach@bingo-ev.de>
Date2022-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]


#13573

FromJamal <nospam@example.com>
Date2022-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]


#13572

Fromdlzc <dlzc1@cox.net>
Date2022-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