aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "multiple inserts in a transaction" Watch "multiple inserts in a transaction" New topic
Author

multiple inserts in a transaction

Mangesh Apte
Greenhorn

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
author
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
Greenhorn

Joined: Sep 28, 2001
Posts: 12
Thanks Peter
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple inserts in a transaction