I am working on a system that needs to be able to handle a high degree of data. On average, the data represents about 500 rows that get written into a database. We want to be able to put through 4000 data objects in 3 minutes. This time frame also includes processing and transforming the data. That equals out to about 2,000,000 database writes in 3 minutes.
Is this possible? Is this something that should be fairly trivial for J2EE to handle or is this pushing its capabilities?
For technology specifics, we are using JMS to move the data around inside the EJB container asynchronously and we are thinking of using Hibernate to do the database writes. We are investigating both JBoss and Sun App Server 8.1 for and will be using Oracle 9i as the DBMS.
Is the above scenario something that can be done inside the EJB container or should we be looking to implement this outside? Benchmarks are always rather ambigous in what they show so I would like some comments from peoples experience.
In terms of the time frame, the 3 minutes is out goal with a hard ceiling of 5 minutes.