Inserts into another BO

intra

Hi everyone,

I am importing a CSV file (approx 5000 lines of data) into a tempBO.

I'm running into some performance issues (to be expected with database inserts) when i transfer rows from one table to the next.

I use the following process

FIND ALL ImportData
CREATE New_Table FOR EACH ImportData With blah blah blah

Does anyone have any better idea's on moving rows of data between BO's in a more speedy fashion?

Regards

Pete.

kklosson

IN BATCHES OF...

RocketRod

make sure there is a good reason to have a second BO. You can always have a status attribute on the original import Bo to flick instances from unverfied to verified or whatever you choose. You can have a process that just adds or sets up the imported data as you want without having to duplicate the data across to another BO.

Cheers Rod