Hello,
I've got a question about running with an asynchronous appserver.
What I want is to do is the following:
AppServer srv-a runs procedure proc-a.
This procedure run a for each no-lock query on a certain table.
Within this query I want to start a program on appserver srv-b.
This program has to be started asynchronous and has to be put in a queue.
The asynchronous AppServer broker for srv-b has to distrubite the queue over multiple servers. Like in a session free state.
This way, I can process whatever I want to process paralel which should improve the performance of this proces.
Has anyone ever done something like this? I really want to know what problems you've encountered and how you solved this. Currently I am having problems with memory violations and the event-procedure not being triggered.
I hope someone can advise me about working this way.
Regards,
Rutger Olthuis,
Ordina OFS
Rutger.Olthuis@ordina.nl
I've got a question about running with an asynchronous appserver.
What I want is to do is the following:
AppServer srv-a runs procedure proc-a.
This procedure run a for each no-lock query on a certain table.
Within this query I want to start a program on appserver srv-b.
This program has to be started asynchronous and has to be put in a queue.
The asynchronous AppServer broker for srv-b has to distrubite the queue over multiple servers. Like in a session free state.
This way, I can process whatever I want to process paralel which should improve the performance of this proces.
Has anyone ever done something like this? I really want to know what problems you've encountered and how you solved this. Currently I am having problems with memory violations and the event-procedure not being triggered.
I hope someone can advise me about working this way.
Regards,
Rutger Olthuis,
Ordina OFS
Rutger.Olthuis@ordina.nl