multiple inserts

View: New views
2 Messages — Rating Filter:   Alert me  

multiple inserts

by Felipe Maza :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

How can I insert an array of DTOs into a database with only a insertion. (i need insert 300 DTOs and using a for is very slow).

Re: multiple inserts

by Gwyn :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Before you get too far into that, are you sure that the reason that using a 'for' is slow isn't that you're using a seperate transaction/commit for each insert?

/Gwyn

On Tue, Jul 8, 2008 at 4:09 PM, Felipe Maza <felipe@...> wrote:
Hello,

How can I insert an array of DTOs into a database with only a insertion. (i need insert 300 DTOs and using a for is very slow).