q:Using AQ effectively ?

 Hi ,
I've to implement an actions system.

I've one side which put action in Advance queue system , and other side (c++ application ) that get the action and do it. Each action has type which use to define connection between action and application (For example 'EMAIL' -- email application)

I've two options to do it in AQ :

1. Define subscriber with a rule DBMS_AQADM.ADD_SUBSCRIBER ( queue_name => 'Queue' , subscriber => new sys.aq$_agent('EMAIL',null,null), rule => 'tab.user_data.type=''EMAIL'' ' ;
2. deqeue user subscriber name.

Or
1. When defining subscriber leave the rule empty. 2. on the DBMS_AQ.ENQUEUE command use
message_properties_t.recipient-_list to define which subscriber should get the message. for example:
declare
...
 a AQ$_RECIPIENT_LIST_T := new AQ$_RECIPIENT_LIST_T(new sys.aq$_agent('EMAIL',null,null));
....

I wonder with of the option will has better performance ? And what the best practice in the area ?  

Amihay Gonen
DBA,
972-3-9268280

Be there ... -> http://golan/Forum%20DBA/default.aspx <http://golan/Forum%20DBA/default.aspx>  

--
http://www.freelists.org/webpage/oracle-l