SQL/MX Queuing and Publish/Subscribe Services

Introduction
HP NonStop SQL/MX Queuing and Publish/Subscribe Services—523734-002
1-7
Comparing Triggers and Publish/Subscribe
Number of processes The same number of processes
service events and actions.
You can scale subscribers
independently of publishers
(you can program multiple
subscribers against one
publisher).
Events versus actions There is a tight coupling
between the number of events
and the number of actions.
A subscriber might see a
row only once after it has
been updated many times.
A subscriber is able to
process many rows in a
single transaction.
SQL/MP vs. SQL/MX Table
Support
Supported for SQL/MX tables. Supported for SQL/MP and
SQL/MX tables.
Table 1-1. Comparing Triggers and Publish/Subscribe (page 2 of 2)
Feature Triggers Publish/Subscribe