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
author
Ranch Hand
Joined: Apr 20, 2000
Posts: 3252
posted
0
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
Mangesh Apte
Greenhorn
Joined: Sep 28, 2001
Posts: 12
posted
0
Thanks Peter
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
