Hey, I am using an OLE DB Destination to enter data into an a400 table and I was getting very slow performance (fastload in not available for this provider). It was doing about 140 rows per minute. In testing i discovered that if i used an ole db
command with a parameterized input statement (insert into library.table(blah, blah blah) values(?, ?, ?)) the performance increased dramatically. To about 1400 rows per minute. My question is, does anyone know what else the ole db destination is doing that
could cause this slow down? Does the destination verify that the row has been inserted afterwords and maybe that could explain why it is so much slower? If so it may be safe to use the ole db command if i simply verify table count after completing the insert
to make sure that all of the rows were entered. Or is there something else that the ole db destination is doing to where it may not be safe to do an ole db command in this way?
View Complete Post