Forums Register Login

MDB vs DB approach

+Pie Number of slices to send: Send
I have a scenerio wherein I am calulating stock indices for large volume.
there are two approaches as listed below, pls help in identifing the best one.

1.We have MDB and all incomming requests are fullfilled and index in calulated in the java application.

2.I have a incomming requested put in DB and a trigger is attached and an Stored Procedure does the calculation does the processing.
+Pie Number of slices to send: Send
The MDB option would give you more control over the resources used. Having a trigger would may just bog down the database server.
+Pie Number of slices to send: Send
Database Triggers are also notorious difficult to put decent exception handling around. Given the choice between Database Triggers and Anything Else... I usually chose the Anything Else.
CAUTION! Do not touch the blades on your neck propeller while they are active. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 668 times.
Similar Threads
pg. 497
Doubt in JMS
MDB related query for defining static variable
JMS scheduling - help
system exceptions
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 12:11:04.