I have a stored procedure that accept 2 values and do an insert into.
Now this must be done to a couple of hundred of thousand of rows.
So I'm thinking the alternatives as an initial test sprout a out of memory error (on only 1000 rows).
What is a better option?
I'm thinking of creating a table and put the values in there. After that using an insert with an "in" clause with (select * from temptable).
Also I'm thinking of see if I can implement a bulk insert somehow as the performance gap is tremendously decreased.
Is this a way to got or is the a better (and not overcomplicated option)