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.