sybperl-l Archive

From: Julia Stone <Julia dot Stone at msdw dot com>
Subject: Is bcp_sendrow() my best option?
Date: Jun 29 2000 2:25PM

I read about using bcp_sendrow() to send an array reference ( using a
loop), and using bcp_batch to commit the rows once the loop is
complete.  I would like to know what would be the best way to insert a
number of rows at once, as opposed to inserting a row at a time with a
loop.  Although bcp_sendrow is supposed to be faster than inserting with
a loop, I would prefer to insert a number of rows at once, and then
commit.   I had hoped that I would be able to accomplish this using some
form of BCP.  Any suggestions?  Thanks.

Julia