Multiple inserts

[sreenivas]

 
Hi All,

I have 3 different "insert" statements for inserting data into different tables and mapped them to with parameter class too.

Now commit the transaction when all 3 inserts are successful, else rollback the transaction even if one of them fails.

As per requirement, these 3 insert statements need to be executed multiple times depending on number of records(in for /while)

Having said that I would like to know ideal mechanism to improve performance & reducing insertion time when there are more than 10000 records to be inserted in this way.

Thanks and regards,
Srini