Re: Experiences with AQ with a very high concurrent workload solicited
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: paulvallee@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Feb 2005 08:40:39 -0800 (PST)
Hi Paul,
I am using AQ in high volume transactions systems.
Oracle AQ is based around the IOT table.
So there is some overhead of PL/SQL API around normal
Oracle INSERT, UPDATE, SELECT, ...
But it is very nice, very transactional and you have
so many nice features around.
Did you mean 200 per second per CPU?
I assume you were thinking about 200 on 1 CPU machine.
The speed will depends on your usage, but 200 is
possible. If you can use 10g then you have bulk AQ
operations similar to bulk (array) DML.
Regards,
Zoran
--- Paul Vallee <paulvallee@xxxxxxxxx> wrote:
> Hello,
>
> We have a client that is considering replacing
> SonicMQ with Oracle AQ
> for an application that currently does up to 200
> messages per second
> and needs to scale well significantly beyond that.
>
> We have AQ experience with some applications that
> did 400 messages per
> minute but that's a far cry from 200 per second
> (12000/minute).
>
> If anyone has experience with Oracle AQ under this
> kind of workload I
> would love to hear of them.
>
> Thanks,
> Paul
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
--
//www.freelists.org/webpage/oracle-l
Other related posts:
