Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: gabe at sio dot ucsd dot edu (Gabriel Lawrence)
Subject: Re: BCP module
Date: Feb 16 1996 4:13PM

> One of the problems is speed. My initial implementation is approx 4x
> slower than pure bcp (though I was running perl and the Sybase server
> on the same machine, so cpu contention was high). But if you need to
> munge the data before sending it into the dataserver then the speed
> issue is less important - you still have process the datafile, which
> will take time.

I have to say that having a programmatic way to process the data and bcp it
up would be extremely handy!

> Is that very different from writing:
>     $dbh->dbcmd("select * from table where $condition");
>     $dbh->dbsqlexec; $dbh->dbresults;
>     $, = '|';   # I want to use | as field separator...
>     while(@dat = $dbh->dbnextrow) {
>         print "@dat\n";
>     }
> I could always put that in somewhere...

it would be nice to have the same api to copy in as copy out...