|
Now, why I use data queues rather than stored procedures: 1. Data queues allow an unlimited number of segments to a message in either direction. I can send a multiple-record update to a server using a data queue; I can't do that with stored procedures. 2. The segments in a message using data queues can be of different layouts. This allows me to make a header/detail query of any complexity, and only return the header information once. With result sets, I have to make multiple requests, or use an inefficient JOIN request that duplicates the header data. Joe > -----Original Message----- > From: Tanveer, Mohammad > > Stored Procedures are very powerfull. I still wonder why people use > MQseries, Data Ques or socket. Please help me understand.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.