I am involved in developing a web application in which data is collected in 8-10 jsp pages(forms) and finally stored in database through session bean using container managed transaction. There will be about 25 inserts on 10 different tables in a transaction. Expected traffic is about 50 submissions per day only. Considering above scenario, do you think I should be worried about any performance issues related to database transactions. The database we are using is Sybase. Thanks in advance.
Peter den Haan
Joined: Apr 20, 2000
No. If you expected all 50 at exactly the same time you might experience some delay, but still no problems. However, load testing is a science, not an art; I would suggest you have a brief go with OpenSTA so that you know how much traffic your site can bear. - Peter