Re: AQ vs. PL/SQL for implementing a messaging queue

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 17 Oct 2004 10:13:55 -0700
Message-ID: <d4d6f278.0410170913.30539763@posting.google.com>

Hi Steve:

If you can, you might want to re-think your design so that instead of having both database transactions and messages, you only have a message. The message itself when received will cause/trigger the database transaction.

If that design change is not workable, then, yes, by all means use AQ. The second approach of simulating a queue without actually having one has all sorts of potential to not be at all scalable and even if you get it working, break down in the future when other application changes come along.

Looping in the application code in a NOWAIT until it succeeds is not where you want to go.

John Received on Sun Oct 17 2004 - 12:13:55 CDT