PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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