Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple inserts in a transaction

 
Mangesh Apte
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic