File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes multiple inserts in a transaction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "multiple inserts in a transaction" Watch "multiple inserts in a transaction" New topic

multiple inserts in a transaction

Mangesh Apte

Joined: Sep 28, 2001
Posts: 12
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
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
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

Joined: Sep 28, 2001
Posts: 12
Thanks Peter
I agree. Here's the link:
subject: multiple inserts in a transaction
It's not a secret anymore!