RE: Trigger Follow Up

>This particular table will be used heavily.
>...
>However, if the Java program simply called a Web Service 
>(residing on an intel machine), would this still cause performance
issues? 

Chad,

Webservices can be fast, really fast, but "fast" is a relative term, as
is "heavily". 

Think about what you're suggesting, for each triggered event
(insert/update/delete/read?) you're going to open a connection to
another machine, send data over the wire, process data on the remote
machine and then send resulting data over the wire, finally closing the
connection to the remote machine. 

What is your definition of "heavily" and how fast do you need it? If
heavy is 10,000 triggers a day the in a typical 8-hour window you're
looking at one every few seconds and I doubt you'd notice it. Then
again, if you're looking at 10,000,000 a day then you're looking at ~350
per second and life will be slow. 

Also, how long does the remote web service take? Remember, the program
that caused the trigger to fire in the first place won't return from
that I/O until this entire process is complete. 

If trigger process involves invoking something on a remote machine I
question the need for the invocation to be synchronous. I think you'd
have a simpler trigger, better performance, and simpler restart if your
trigger simply wrote a record somewhere (or used a DataQ*) to indicate
that the remote web service needed to be invoked and then you invoked
that web service from a batch job whose job was to invoke this web
service. 

-Walden

* Remember, DataQ's can't be backed up.


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of cornelius, chad
Sent: Monday, September 19, 2005 9:12 AM
To: 'Java Programming on and around the iSeries / AS400'
Subject: Trigger Follow Up

I sent a question regarding triggers a few months back and have a follow
up
question.  Several of you mentioned that calling a Java program from an
RPG
trigger program could have a performance impact if the table is heavily
used.  This particular table will be used heavily.  However, if the Java
program simply called a Web Service (residing on an intel machine),
would
this still cause performance issues?  Is it the call to the Java program
that impacts the system?

 

Also, I was wondering if anyone had tried to compile Kevin Vandever's
example of starting the JVM prior to calling Java methods?  When I try
to
create my bound program that binds to Module (JVMModule) , which copies
QSysInc/QRpgLeSrc,JNI, I receive a lot of authority errors such as "The
user
is not authorized to service program QCSTCRG1 in library QSYS."

 

Thanks,

Chad Cornelius, IIS

(720) 921-7835