Home » Server Options » Streams & AQ » AQ or Streams (10g R2)
AQ or Streams [message #504310] Sat, 23 April 2011 08:02 Go to next message
GSREDDY
Messages: 13
Registered: October 2005
Location: Hyderabad
Junior Member
We have a requirement like whenever user does some operation on a table(insert/update/delete), it should replicate the same into some another tables based on some application functionality. Sometimes it can be 100 records and sometimes it will be some million records(I think triggers is a bad idea). Here all tables will be in the same schema and user is a single user for our testing and at client site there will be some 100-250 users.

Which option you suggest to achieve this, Streams or Advanced Queues?

Report message to a moderator

Re: AQ or Streams [message #504313 is a reply to message #504310] Sat, 23 April 2011 09:02 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the difference between Streams and AQ?

Regards
Michel

Report message to a moderator

Previous Topic: Why can't I enqueue a message with String attributes?
Next Topic: Asynchronous Auto Change Data Capture - Data Recovery from REDO Log files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 13:12:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.