batchprocessor and databroadcast

Questions, tips and tricks and techniques for scripting in Servoy

batchprocessor and databroadcast

Postby Hans Nieuwenhuis » Tue Sep 27, 2011 9:15 am

Hi,

I have an Erp solution running on servoy server.

On the same servoy server there is a batchprocessor that will add records to tables that are also shown in the Erp solution.

I notice that when the table is shown on a form in the Erp solution, I still have to do " show all records" to make records added by
the batchprocessor visible.

Is it possible to see new records without the user having to push " show all records" ??

Maybe by catching the ondatabroadcast ?

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: batchprocessor and databroadcast

Postby jcompagner » Tue Sep 27, 2011 9:50 am

you could use the ondatabroadcast for that.
Also you could show a relation on the screen, that will then update itself

Besides that if you have a foundset that is fully loaded and doesn't have any find/where statements then i think we should also auto add the new row.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: batchprocessor and databroadcast

Postby jasantana » Tue Sep 27, 2011 10:07 am

Hi have a similar issue with headless client.

From an option in my solution the SHC is invoked and adds some records to a table. After that the user goes to the option where those records can be treated and they are not there until he navigates to next record.

Thanks.
Best regards,
Juan Antonio Santana Medina
jasantana@nephos-solutions.co.uk
Servoy MVP 2015
Servoy 6.x - Servoy 7.x - Servoy 8.x - MySQL - PostgreSQL - Visual Foxpro 9
User avatar
jasantana
 
Posts: 555
Joined: Tue Aug 10, 2010 11:40 am
Location: Leeds - West Yorkshire - United Kingdom

Re: batchprocessor and databroadcast

Postby ngervasi » Tue Sep 27, 2011 10:41 am

I have the opposite need: I'd like to turn off databroadcast when an HC performs some rows insert, is this possible? I'd like to avoid 100+ clients receiving the databroadcast notifications, especially the client that triggered the operation.
Nicola Gervasi
sintpro.com
SAN Partner
ngervasi
 
Posts: 1485
Joined: Tue Dec 21, 2004 12:47 pm
Location: Arezzo, Italy

Re: batchprocessor and databroadcast

Postby Hans Nieuwenhuis » Tue Sep 27, 2011 10:58 am

Thanks Guys,

@Johan : if a relation is used and the user has done a find - search on that related foundset, will the new record still become visible ?

If so, I wonder why there is a difference in behaviour between a non-related and a related foundset regarding databroadcast ??

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: batchprocessor and databroadcast

Postby jcompagner » Tue Sep 27, 2011 11:03 am

because for none related it can be anything.. you can have find criteria that are very hard to do.
For related it is a fixed set, that we quickly test and if we do think, ok this one could (and i stress here could we don't know it for sure!) we do a re query.
That is quite hard to do for a normal foundset then we constantly have to refresh them, quite a performance penalty
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: batchprocessor and databroadcast

Postby martinh » Tue Sep 27, 2011 12:02 pm

jcompagner wrote:That is quite hard to do for a normal foundset then we constantly have to refresh them, quite a performance penalty


This is really true. For updates the data broadcasting is working, and in some cases I would even like NOT to have data broadcasting.

Capture.JPG
Capture.JPG (21.07 KiB) Viewed 4843 times


Calculate the nr of hours that the system is refreshing.
As you can see that this refresh operation already has a very bad influence on the performance.
The avg time to refresh is significant higher than a normal operation.

I'm even going to rewrite some forms (forms based on datasets in stead of foundsets) to avoid this data broadcasting
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: batchprocessor and databroadcast

Postby martinh » Tue Sep 27, 2011 12:05 pm

ngervasi wrote:I have the opposite need: I'd like to turn off databroadcast when an HC performs some rows insert, is this possible? I'd like to avoid 100+ clients receiving the databroadcast notifications, especially the client that triggered the operation.


+1

I already asked that earlier, but it seemed to be very difficult.
Maybe the easiest way for Servoy would be a setting on table level if data broadcasting must be ignored.
In that case it would be system wide and perhaps easier to implement.
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium


Return to Methods

Who is online

Users browsing this forum: No registered users and 8 guests

cron