Best Practices - Adding records to Db

[SteveDoc]

Hi all

Could someone shed some light on best practices for adding records to a database table.

Currently my application accesses a group Inbox in Lotus notes and filters the emails for a specific date. Then processes the body of the email to return the applicants FirstName, surname etc. These values are passed to variables.

Would the best practice be to run the Insert Sproc per record ?
What are my other options for adding these records to the Db Table?

Thanks in advance

 

[cjard]

Currently my application accesses a group Inbox in Lotus notes and filters the emails for a specific date. Then processes the body of the email to return the applicants FirstName, surname etc. These values are passed to variables.

Would the best practice be to run the Insert Sproc per record ?

That's your only option. High end DB systems like oracle can bulk load using arrays, but even then, all its doing is sending the data to Oracle and then Oracle itself repeatedly calls the sproc

What are my other options for adding these records to the Db Table?

None